Posted to microsoft.public.excel.misc

Otto Moehrbach Otto Moehrbach is offline

external usenet poster

Posts: 1,090

More than i substitution

Excel XP & Win XP
I am using the Substitute function in conjunction with the Indirect function
in a Data Validation formula. My question is about the Substitute function.
Is there a way to substitute nothing for more than one thing in a single
formula? For instance, substitute nothing for all spaces, all commas, all &
symbols, etc, all in one formula? Thanks for your time. Otto

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
substitution: a better method?	tjtjjtjt	Excel Worksheet Functions	8	November 8th 07 09:47 PM
Substitution of words	jkowalik	Excel Discussion (Misc queries)	2	September 9th 07 02:24 PM
Substitution	Mitchell	Excel Discussion (Misc queries)	4	December 19th 06 07:22 PM
substitution	Cossloffe	Excel Discussion (Misc queries)	1	June 4th 06 07:10 AM
Substitution	Boenerge	Excel Discussion (Misc queries)	2	May 23rd 05 12:14 PM

All times are GMT +1. The time now is 05:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us