Trim spaces on both sides

[Eric]

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

 

[Tom Ogilvy]

Trim does what you describe. It removes spaces [ chr(32) ] on each end.
Perhaps you have some characters besides chr(32) that look like spaces.
chr(160) for example.

If so, and you use Excel 2000 or later, you could use the replace function
to clean those. You might have to parse out the string and see what you
have.

 

[kkknie]

Trim works fine for me, what code are you using

 

[David McRitchie]

Hi Eric,
An example of a macro using TRIM
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

If it doesn't work you will have to determine what characters you
actually have see the topic above that one.

Also check to see what you get
="*" & A1 & "*"
="*" & TRIM(A1) & "*"
=CODE(A1)