View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SANDIND[_2_] SANDIND[_2_] is offline
external usenet poster
 
Posts: 16
Default 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