Looking for TRIM macro...

[Smonczka]

I'm looking for the code to create a macro that will trim a range or
highlighted section of a spreadsheet. I found this once before on the
web but can't seem to locate it anymore. Does anyone happen to have
this?

Thanks
Steve

 

[Andy Pope]

Hi,

Maybe it was this page.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Cheers
Andy

 

[Bob Phillips]

Dave McRitchie's all-encompassing TRIMALL function
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Smonczka]

Thanks for the help! That was just what I was looking for.