Search / Replace

[Abby Rosenblum]

Anyone know how delete the ISBN: if the cell contains the following?

ISBN: 0670844802

I just want the number incuding the zero but sometimes its a one.

I've got about 1,500 to do so I want to search and replace. When I leave
the Replace With field blank, the entire cell is returned blank.

Thanks in advance!

Abby

 

[Earl Kiosterud]

Abby,

Good. Fun, isn't it.

Just so you'll know, this should be posted as a reply to your original post.
Or did CDO do this?

 

[Dave Peterson]

Hmmm.

I did an Edit|replace
Find what: isbn: (with a trailing space)
replace with: (leave blank)

And xl2002 changed it correctly. I did have to give the range a special format
of 0000000000 so that the leading zeros would show up.

If it's ok to treat the values as text, this worked, too:
I did an Edit|replace
Find what: isbn: (with a trailing space)
replace with: ' (single apostrophe)

 

[Abby Rosenblum]

The leading zero was going to be my next question! Thanks!

 

[Earl Kiosterud]

Methinks I replied to the wrong post. Forget this.