Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Trim

5 views
Skip to first unread message

Lyn Machado

unread,
Feb 9, 2003, 3:59:12 AM2/9/03
to
Hi.. Does anyone have a macro to trim leading and trailing spaces for a
workbook instead of me performing this task using the "trim" function?
Lyn


Tony

unread,
Feb 9, 2003, 5:03:16 AM2/9/03
to
Try ASAP utilities, it is a free add-in and includes over 300 utilities
including the option to trim spaces.
http://www.asap-utilities.com/

Tony

"Lyn Machado" <Lyn...@hotmail.com> wrote in message
news:O#9HVlB0CHA.2684@TK2MSFTNGP11...

Ron de Bruin

unread,
Feb 9, 2003, 5:57:32 AM2/9/03
to
See Trimall from David

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Regards Ron de Bruin
(Win XP SP-1 XL2002 SP-2)
www.rondebruin.nl


"Lyn Machado" <Lyn...@hotmail.com> schreef in bericht
news:O#9HVlB0CHA.2684@TK2MSFTNGP11...

Lyn Machado

unread,
Feb 9, 2003, 10:36:34 AM2/9/03
to
Thanks guys.... just what i needed. Lyn
"Tony" <tony-...@notvalid.com> wrote in message
news:u9YdrJC0CHA.2288@TK2MSFTNGP09...
0 new messages