[NTLUG:Discuss] DB help

[Fred]

I have a list of names, addresses and other data in a spreadsheet
(OpenOffice calc, one field per column) and I am trying to figure
out how to make mailing labels from that data. A complicating factor 
is that street numbers, names, types (dr, ave, etc) and direction
are all different columns and need to be concatenated into one
"address" field. ex: 1234 Main St W is in Calc as 4 separate 
entries, "1234", "Main", "St", "W".

OpenOffice's help file isn't too helpful and I haven't run across
anything useful on the web, so far.

Anyone here have any insight on how  I should proceed,
other than the obvious "very carefully"? 

Fred



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com