LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Gumby
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stack Chart Legend Display John Charts and Charting in Excel 1 May 15th 05 03:44 AM
Plot 2 variables on Y axis nemme Charts and Charting in Excel 1 March 18th 05 08:17 PM
excel stack tabs in groups, less scrolling L2R, hovering over gro. Stephen Robb Excel Discussion (Misc queries) 1 February 18th 05 11:48 PM
LINEST maximum number of predictor variables Peter N Excel Worksheet Functions 7 February 17th 05 10:14 AM
Index Match With 3 Variables Scooterdog Excel Worksheet Functions 5 January 2nd 05 07:05 PM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"