Posted to microsoft.public.excel.programming

Thang

external usenet poster

Posts: 5

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Edit REplace String	Tami	Excel Worksheet Functions	2	September 25th 09 08:20 PM
How do I replace last numeric string from a alphanumeric string?	Christy	Excel Discussion (Misc queries)	3	August 11th 06 12:17 AM
Substring to replace string	Andrew Slentz[_2_]	Excel Programming	3	June 11th 04 06:54 PM
Substring to replace string	Andrew Slentz[_2_]	Excel Programming	1	June 11th 04 04:51 PM
replace a number with a string from database	K.Martens	Excel Programming	1	November 6th 03 10:27 PM

All times are GMT +1. The time now is 03:53 PM.

About Us

"It's about Microsoft Excel"