Link to home
Start Free TrialLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of longtruong
longtruong
Flag of Viet Nam image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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