EXCEL - Multiple lines of text in a cell 2

[jawshark]

I'm trying to concatenate 3 different cells into a single cell that has each of 3 origianl cells' contents on it's own line.

For Example:

Given the below:

a2 a3 a4
John Doe 123 A Rd City,ST,Zip

I would like to have:

a1
John Doe
123 A Rd
City,ST,Zip

I know I can use ALT+ENTER when editing a cell to enter a "hard" return, but I'd like to do this with concatenation, AND not have to write a macro. I thought it would be quick and easy... The function CHAR doesn't do it.

Any help would be appreciated.

Thanks,
Mike

 

[DaleWatson123321]

Hi Mike

GOOD news. The following will work...

=A2&CHAR(10)&A3&CHAR(10)&A4

Be sure to format the cell - i.e. Format - Cells - Alignment - Vertical: "Top", Text control: "Wrap text".

Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[xlhelp]

Dale!

Thank you.

I learnt something new today.

Indu

 

[jawshark]

Dale:

IT WORKS!! Thank you very much! A simple LF - I fell like a dummy.

Thanks again,
Mike

 

[jawshark]

fell ==> feel

Now I really feel like a dummy...

Mike

 

[DaleWatson123321]

Indu and Mike,

Thanks for the STARS !!!!

I'm glad I was able to help.

Regards, ...Dale

P.S. Mike - we've ALL been down that road on a cloudy day ;-)