=Street & char(10) & town & char(10)

turn on word wrap for the cell with the formula

--
Regards,
Tom Ogilvy


"Rebuckley" wrote in message
oups.com...
I am trying to CONCATENATE cells of an address into a single cell, but
I would like to have an "alt-ENTER" between each piece of information
so it appears as real address...any way this can happen??

streettowncitystatezip

to be as -
street
town
city
state
zip

??