View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default replace a string in the worksheet

If you use TOBEOUT, make sure you specify whole cell.

--
Regards,
Tom Ogilvy

"kkknie" wrote in message
...

You'll need to do three find/replaces. Click the box above row one and
to the left of column A to select all cells. Then hit Ctrl-H to open
Find/Replace dialog.

First Find IN and replace with TOBEOUT and replace all.
Next Find OUT and replace with IN and replace all.
Finally, Find TOBEOUT and replace with OUT and replace all.

K


--
kkknie
------------------------------------------------------------------------
kkknie's Profile:

http://www.excelforum.com/member.php...fo&userid=7543
View this thread: http://www.excelforum.com/showthread...hreadid=267298