View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeffery B Paarsa Jeffery B Paarsa is offline
external usenet poster
 
Posts: 17
Default Removing leading and trailing space...

Hello,

I have a multi sheet excel spread sheet and I would like to remove the
leading and trailing space from all the Cells of these sheets. TRIM(A&i)
only does it on a single column how can this be done on all the columns and
sheets in a single run?

Any sample code/iead?

--
Jeff B Paarsa