Search / Replace

  • Thread starter Thread starter Abby Rosenblum
  • Start date Start date
A

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
 
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? :)
 
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)
 
Back
Top