• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

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?
0
morinia
Asked:
morinia
1 Solution
 
longtruongCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now