ExcelBanter - Using Concatenate but splitting line with "tab"

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using Concatenate but splitting line with "tab" (https://www.excelbanter.com/excel-programming/341971-using-concatenate-but-splitting-line-tab.html)

Rebuckley

Using Concatenate but splitting line with "tab"

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

??

Tom Ogilvy

Using Concatenate but splitting line with "tab"

=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

??

All times are GMT +1. The time now is 02:42 PM.