# Finding First 3 characters after a comma, hyphen..

#### questforexcel

##### Board Regular
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.

Thank you,

Last edited:

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=MID(A2,FIND("-",A2)+2,3)``

#### Marcílio_Lobão

##### Well-known Member
questforexcel, Good morning.

Try to use: B1 -->
Excel Formula:
``=MID(A1;FIND("- ";A1)+2;3)``

Please, tell us if it worked for you.

I hope it helps.

#### questforexcel

##### Board Regular
Excel Formula:
``=MID(A2,FIND("-",A2)+2,3)``
Thank you so much for the quick response and help! This worked!!

#### Fluff

##### MrExcel MVP, Moderator
Glad we could help & thanks for the feedback.

#### questforexcel

##### Board Regular
questforexcel, Good morning.

Try to use: B1 -->
Excel Formula:
``=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

Replies
1
Views
175
Replies
5
Views
883
Replies
5
Views
220
Replies
39
Views
1K
Replies
4
Views
326

1,141,818
Messages
5,708,763
Members
421,588
Latest member
Wawie

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back