Extracting text between 2 special characters

[rangequestion]

Hi,

I have a column of text fields and I'd like to extract the text in each cell based on 2 conditions. I need to extract the text that comes after the very first dahs (-) AND before the colon ). For example I have the following string:

MT202I-ACB: /BNF/

And I only want to extract "ACB". Note that the length of text that I want extracted can vary. It can be either 2, 3 or 4 characters long.

thanks!

 

[Rick Rothstein]

Hi,

I have a column of text fields and I'd like to extract the text in each cell based on 2 conditions. I need to extract the text that comes after the very first dahs (-) AND before the colon ). For example I have the following string:

MT202I-ACB: /BNF/

And I only want to extract "ACB". Note that the length of text that I want extracted can vary. It can be either 2, 3 or 4 characters long.

Assuming your single example is representative of what all your data could like, give this formula a try...

=MID(LEFT(A1,FIND(":",A1)-1),FIND("-",A1)+1,99)

 

[admiral100]

Another way:-

=MID(A2,FIND("-",A2)+1,FIND(":",A2)-FIND("-",A2)-1)

 

[rangequestion]

Both work like a charm, thanks!