Posted to microsoft.public.excel.programming

SANDIND[_2_] SANDIND[_2_] is offline

external usenet poster

Posts: 16

Add - Trim(Clean())

Hi, I have more than 1000 formulaes in one sheet and to all those formulaes I
want to add Trim and Clean function. Is there anyways to add these two
functions to all the formulaes.

Also if there is any option to use a VB code that would trim and clean all
the selected data in spreadshet , this way i could avoid adding those to
formulaes already in sheet.

Thanks for help.
--
SS

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
VLOOKUP Trim vs. No Trim	Kigol	Excel Programming	2	October 3rd 07 05:14 PM
Trim and clean	Wanna Learn	Excel Discussion (Misc queries)	2	January 30th 07 07:08 PM
Trim function doesn't clean out ASCII Code 160 (Space)	Ronald Dodge	Excel Worksheet Functions	6	January 27th 05 03:48 AM
VBA Trim and Application.worksheetfunction.Trim	Hari Prasadh	Excel Programming	3	January 19th 05 02:22 PM
Trim like worksheet Trim	Bob Phillips[_5_]	Excel Programming	0	August 20th 03 07:10 PM

All times are GMT +1. The time now is 06:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us