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


You do realize that this will screw up your ability to sort the data.
A better solution would be to describe what you want to do with the
data. You may not need it in the format you describe. There may
be other methods. Like using mail merge to create address labels
for example.

gls858