Looking for TRIM macro...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Smonczka - 13 Dec 2006 14:16 GMT

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

Reply to this Message

Andy Pope - 13 Dec 2006 14:31 GMT

Hi,

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

Cheers
Andy

> 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
[quoted text clipped - 3 lines]
> Thanks
> Steve

Reply to this Message

Bob Phillips - 13 Dec 2006 14:34 GMT

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

Signature

HTH

Bob Phillips

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

> 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
[quoted text clipped - 3 lines]
> Thanks
> Steve

Reply to this Message

Smonczka - 14 Dec 2006 15:10 GMT

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

Reply to this Message