Adding lines to a cell

[fansoffloyd]

I am trying to make one cell reference a bunch of other cells and have the information presented in that cell in a certain way.

I have it set up where I can type in "Bob" into cell A1 and "book interview" into cell 2 and "Colorado" into cell 3.

Cell B1 comes back with "Who: Bob What : Book Interview Where: Colorado"

I want it to make a new line for each entry but stay in the same cell so it looks like this :
Who:Bob
What:Book Interview
Where: Colorado

Here is my current Formula into cell B

="WHO: " & A2 & " " & "What:" & A3 & " Where: " & A4 & " "

The extra Quotations are my attempt to add spaces to cause the lines to move down but that doesn't seem to be working consistently

Any help would be appreciated.

Thank you All!

[DBY]

Hello
Try:

Please Login or Register  to view this content.

And apply 'Wrap Text' to cell.

Hope this helps.
DBY

[DBY]

Just noticed you're in the 'Other Platforms' forum with your profile stating Excel 2007. The above reply refers to that.

DBY

[shyamhappy]

Even below might help you

Please Login or Register  to view this content.

______________________________________________________________________________________________
if you feel some one has helped you please click * to add to reputation

“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison