Extracting information from Text Strings in Excel
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 problem i am having is that the two text strings can be different lengths.
Any help would be greatly appreciated.