I have two possible types of text string in Excel, either DA3-AJ33S-5P1 or DA3-AJ150S-5P1. I want a formula that extracts the middle part of the text string i.e. the "AJ33S" or the "AJ150S" - the ...

Is there any way of extracting a numerical value from a string when the number of alpha and numeric characters is variable? This is to cope with a situation where someone might just enter '10' but ...

To measure the length of any string you can use the LEN function in Excel, which returns the exact length of the string from which you can make the request you want. To better understand the syntax ...