View Single Post
  #4   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

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