replace a string in the worksheet
 

Hello,

how can I replace the string "IN" by "OUT" and "OUT"
by "IN" in all cells in my worksheet?

Many thanks for your help,

Thang

replace a string in the worksheet
 

You'll need to do three find/replaces. Click the box above row one an
to the left of column A to select all cells. Then hit Ctrl-H to ope
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.



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26729

replace a string in the worksheet
 

Use Edit=Replace

Replace IN with ZZXX (or any unique string)
Replace OUT with IN
Replace ZZXX with OUT

--
Regards,
Tom Ogilvy

"thang" wrote in message
...
Hello,

how can I replace the string "IN" by "OUT" and "OUT"
by "IN" in all cells in my worksheet?

Many thanks for your help,

Thang

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