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.


"mrmnz" wrote:

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.

I would try DataText to ColumnsDelimited by other(-)Next.

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

Just the numbers will remain.


Gord Dibben MS Excel MVP

On Tue, 30 Sep 2008 14:05:03 -0700, mrmnz
wrote:

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.

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"

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



"mrmnz" wrote:

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"