Using Find and Replace (200)

Topic

New Reply

I am trying to do a find and replace in Excel but don’t think it is possible.

What l am trying to do is to replace:

LEOPARDGENHUMS

to

G:

see screenshot.

Reply | Quote

Replies

Hi jj,

Your screenshot explains why you’re not getting a match! Hint: Look at your search string.

Cheers

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

I will do that, thanks.

Reply | Quote

Besides the extra leading , you may also want to upgrade Excel 200 to Excel 2000 (or higher). I don’t think I was around at that time, so I cannot vouch for the efficiency of the find and replace command in that version…

Cheers

Reply | Quote

The lack of a the dbl slashes () may be the reason why, in the thread starting at post 575,393 , you could not get the code to find the files with the network names.

Steve

Reply | Quote