Trying to stack 2 variables on each other in one sheet
 

I have a master sheet which pulls information from other sheets. Gives me
something like:

='Monday'!B9&'Tuesday'!B9

results look like this:

answer1answer2

How would I get it to alt enter and make the results:

answer1
answer2

in the same cell?

Try this ...
='Monday'!B9&CHAR(10)&'Tuesday'!B9
Rgds,
ScottO

"Gumby" wrote in message
...
| I have a master sheet which pulls information from other sheets. Gives me
| something like:
|
| ='Monday'!B9&'Tuesday'!B9
|
| results look like this:
|
| answer1answer2
|
| How would I get it to alt enter and make the results:
|
| answer1
| answer2
|
| in the same cell?

Try setting your alignment to wrap text and then use:

='Monday'!B9&char(10)&'Tuesday'!B9


--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Gumby" wrote in message
...
I have a master sheet which pulls information from other sheets. Gives me
something like:

='Monday'!B9&'Tuesday'!B9

results look like this:

answer1answer2

How would I get it to alt enter and make the results:

answer1
answer2

in the same cell?