TRIM - Excel97

  • Thread starter Thread starter FRANK
  • Start date Start date
F

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.
 
Do I go to the address at the end of your message?
-----Original Message-----
You need............... wait for it....................
Click to expand...
TrimAll !!!!! A wonderful little
utility from Dave McRitchie that will bring sunshine back
Click to expand...
into your life, and reassure you that it
 
Tried your Trim-All!!! :) :) :) :) and life is indeed
worth living again. Works great. Many thanks.
Frank
-----Original Message-----
You need............... wait for it....................
Click to expand...
TrimAll !!!!! A wonderful little
utility from Dave McRitchie that will bring sunshine back
Click to expand...
into your life, and reassure you that it
 
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>
 
Give it back - It's still ours - You're just borrowing it - It's ours I tell you
OURS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! <vbg>
 
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.
 
Back
Top