Delete <space> if at beginning or end of value?

[eepok]

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.

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?

 

[KeithG]

Use the Trim function

Trim([Field])

 

[eepok]

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.

 

[KeithG]

#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)!

 

[boblarson]

You, sir, are one helpful person.

Yeah, Keith's good, even if he is from Illinois

 

[sbenj69]

Yeah, Keith's good, even if he is from Illinois

yeah, but I bet he's not from the "Redneck" part of Illinois

 

[KeithG]

I live in the Springfield Illinois.