Removing text before a hypen [-]

  • Thread starter Thread starter mrmnz
  • Start date Start date
M

mrmnz

I have a list as follows:
timothy - 29
james - 32
brian - 41

I want to get rid of the "timothy - " so just "29" remains.

I have tried Find and Replace using ? - and * - and leaving replace empty.
But it doesn't work. What am I doing wrong?

Thanks.
 
Find/Replace using *- worked fine for me. You can also try using Data/Text
To Columns using "-" as the delimiter to separate the text and delete the
column of names you don't need.
 
I would try Data>Text to Columns>Delimited by other(-)>Next.

Select column 1 and "do not import(skip)" and Finish.

Just the numbers will remain.


Gord Dibben MS Excel MVP
 
OK - that's was great. Thanks a lot.

Now how do I do the same thing but this time removing the " - 29" and
leaving just "Timothy"
 
Back
Top