Hey all,

I got a massive lump of WORD documents with Avery Mail label tables -- each avery mail label template/table has a mailing address. This how these people store their data. :mad::confused::mad:

So I went through and over a couple days transfered all 458 records to an excel spreadsheet for easy importing to my access mailing database. Problem is that I forgot to clean up a couple of the fields and now I have all these values with unnecessary spaces as the first or last characters for a lot of values.

My question:
Could anyone help me remove the first and/or last character of these values if the character is " "? Would it be easier to do this in excel and just re-import?

Use the Trim function

Trim([Field])

Use the Trim function

Trim([Field])

Thanks super mucho. I would add to your rep, but apparently I need to spread the love before I can add to your rep again. You, sir, are one helpful person.

#3 Today, 10:38 AM
eepok
Registered User Join Date: Oct 2007
Posts: 45


Quote:
Originally Posted by KeithG
Use the Trim function

Trim([Field])

Thanks super mucho. I would add to your rep, but apparently I need to spread the love before I can add to your rep again. You, sir, are one helpful person.


Send beer(LOL)!:D

You, sir, are one helpful person.
Yeah, Keith's good, even if he is from Illinois :D

Yeah, Keith's good, even if he is from Illinois :D
yeah, but I bet he's not from the "Redneck" part of Illinois :p

I live in the Springfield Illinois.