Using Find and Replace (200)

**jj1234** · 2006-05-31 07:31

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.

**macropod** · 2006-05-31 07:48

Hi jj,

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

Cheers

**jj1234** · 2006-05-31 08:24

I will do that, thanks.

**Rudi** · 2006-06-01 05:28

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 <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

**sdckapr** · 2006-06-01 08:24

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

Steve

Thread: Using Find and Replace (200)

Thread Tools