Posted to microsoft.public.excel.misc

fluffy

external usenet poster

Posts: 18

Find and replace

I have a spreadsheet where I need to replace the single number "1" with a "0"
but not the "1" if it is included in another number. i.e. 11, 12, 21,
31....etc

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
find and replace	jason2444	Excel Discussion (Misc queries)	1	November 17th 06 04:13 PM
How to cancel a find & replace command "midstream"?	Matt from GVA	Excel Worksheet Functions	4	September 4th 06 05:47 PM
Macro: Find and replace	Bertie	Excel Discussion (Misc queries)	1	May 29th 06 02:01 PM
Find and Replace	blakrapter	Excel Worksheet Functions	3	December 15th 05 12:25 AM
VB Find and Replace	Bony_Pony	Excel Worksheet Functions	10	December 6th 04 05:45 PM

All times are GMT +1. The time now is 08:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us