replace a string in the worksheet

[thang]

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

 

[kkknie]

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.

 

[Tom Ogilvy]

Use Edit=>Replace

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

 

[Tom Ogilvy]

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