Avatar of morinia
morinia
Flag 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?
Microsoft Excel

Avatar of undefined
Last Comment
SiddharthRout

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
longtruong

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SiddharthRout

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
Your help has saved me hundreds of hours of internet surfing.
fblack61