Home » Any Answers » Extracting information from Text Strings in Excel

Extracting information from Text Strings in Excel

Posted by jasongibson PM | on Mon, 25/06/2012 - 10:18  657  7 comments | report

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.

Comments
There are 7 comments. Login or register to view them.

Jason

Richard Willis | Mon, 25/06/2012 - 10:36
Richard Willis's picture

Richard's not wrong (completely)...

George Attazder | Mon, 25/06/2012 - 10:55
George Attazder's picture

Eh?!

Richard Willis | Mon, 25/06/2012 - 11:05
Richard Willis's picture

Sucess

jasongibson | Mon, 25/06/2012 - 11:04

Jason

Richard Willis | Mon, 25/06/2012 - 11:06
Richard Willis's picture

Apologies

George Attazder | Mon, 25/06/2012 - 11:08
George Attazder's picture

.

cparker87 | Mon, 25/06/2012 - 12:26