Use Word's mail merge feature. This is a perfect reason for it. :)
http://www.officearticles.com/word/m...osoft_word.htm

You may want to use a directory merge.

--
~Anne Troy
www.OfficeArticles.com


"STEVE" wrote:

I have Name, PO Box, street address, city, state, zip across a row in 6
seperate cells/columns.

I want to have this format in 1 cell:

Name
PO Box
Street address
City, State Zip