Removing text before a hypen [-]

[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.

 

[JMB]

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.

 

[Gord Dibben]

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

 

[mrmnz]

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"

 

[mrmnz]

It's OK guys - I've found out how to do it thanks to you and your help.