TRIM - Excel97

[FRANK]

I have several spreadsheets with several columns that
contain description information. They look something like
this:
PART25 INN
PART25 INN
PART25 INN
PART26 OUT
PART26 OUT
etc.
I know that individually I can use the Trim function to
fit this. But I have 8 spreadsheets with several thousand
records each and this would be a very time comsuming way
to fix this problem. Is there any way that I can automate
this process to trim down these fields. Any suggestions
would be appreciated.

 

[Ken Wright]

You need............... wait for it.................... TrimAll !!!!! A wonderful little
utility from Dave McRitchie that will bring sunshine back into your life, and reassure you that it
is indeed still worth living ( It's been a long day!!! ;-> )

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

 

[FRANK]

Do I go to the address at the end of your message?

-----Original Message-----
You need............... wait for it....................

TrimAll !!!!! A wonderful little

utility from Dave McRitchie that will bring sunshine back

into your life, and reassure you that it

 

[FRANK]

Tried your Trim-All!!! and life is indeed
worth living again. Works great. Many thanks.
Frank

-----Original Message-----
You need............... wait for it....................

TrimAll !!!!! A wonderful little

utility from Dave McRitchie that will bring sunshine back

into your life, and reassure you that it

 

[Ken Wright]

Not mine - Dave's (But now that I have it, he's not getting it back - I need it - It's mine I tell
you, mine!!!!!!!!!!!!!) <g>

 

[Ken Wright]

Give it back - It's still ours - You're just borrowing it - It's ours I tell you
OURS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! <vbg>

 

[Norman Harker]

Hi Ken!

You're not related to George III are you? I'm beginning to see a
resemblance.

And here's me thinking that on July 4th the whole tone of the place
would improve.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Friday: Guam (Independence Day); Faroe Islands
(Varmakeldustevna); Haiti (Day of Agwe); Latvia (Jewish Genocide
Commemoration); Lesotho (Family Day); Marshall Islands (Fisherman’s
Day); Norway (Queen Sonja’s Birthday); Philippines (United States
Friendship Day); Puerto Rico (For US Independence Day); Switzerland
(Aarauer Maienzug); Rwanda (Independence Day); Tonga (King’s Day);
United States (Independence Day); Virgin Islands (US Independence
Day); Yugoslavia (Freedom Fighter’s Day)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.