How do I retrieve only the characters after a "-" in a string - Excel 2007

I have a string of data that has a data of different lengths after the "-".  I would like to get only the data after the hyphen.  Field = $B$7

ie   - 100000 - England
        200000 - Dominican Republic
        300000 -  United States
        400000 - Federation of South Africa

How can I do this?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
longtruongConnect With a Mentor Commented:
Hi Morinia,

You can try this formula:

=MID(A1,FIND("- ",A1)+2,LEN(A1))

A1 is referred to the cell which contains your data (i.e. 1000000 - England).

Hope it helps.

Long
0
 
SiddharthRoutCommented:
If you have a column full of data then I would advise you to use Excel's inbuilt feature which is "Text To Columns" using "-" as a delimiter.

Sid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.