View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_6_] Eric[_6_] is offline
external usenet poster
 
Posts: 23
Default Trim spaces on both sides

Hi There,

How do you trim spaces a text in a column content on both
sides say for example leading and trailing spaces before I
save them to a CSV file. I am creating a macro that do
automatically save my file without modifying them manually.

I use TRIM but it didn't work.

TIA
Eric