Finding First 3 characters after a comma, hyphen..

[questforexcel]

Hi All,

Looking for some help on how to extract the first 3 characters from an alpha numeric data in a cell.

For eg.
"1234 - MUM Records Inc"
"4567 - SYD Books Inc"

I need a formula to extract the first 3 characters after the "-" above, so in the first case it should be "MUM" and in second "SYD"

May be there is a very simple formula but not able to get it.

Also there are spaces between numbers at the start, the "-" and the words after "-"
I tried using TRIM function but that did not remove the spaces, is there another these could be removed.

Would appreciate all your help.

Thank you,

 

[Fluff]

How about

=MID(A2,FIND("-",A2)+2,3)

 

[Marcílio_Lobão]

questforexcel, Good morning.

Your data at A1.

Try to use: B1 -->

=MID(A1;FIND("- ";A1)+2;3)

Please, tell us if it worked for you.

I hope it helps.

 

[questforexcel]

How about

=MID(A2,FIND("-",A2)+2,3)

Thank you so much for the quick response and help! This worked!!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[questforexcel]

questforexcel, Good morning.

Your data at A1.

Try to use: B1 -->

=MID(A1;FIND("- ";A1)+2;3)

Please, tell us if it worked for you.

I hope it helps.

Thank you for your message and trying to help. It worked with the formula given on the first reply Thank you