| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stack Chart Legend Display | Charts and Charting in Excel | |||
| Plot 2 variables on Y axis | Charts and Charting in Excel | |||
| excel stack tabs in groups, less scrolling L2R, hovering over gro. | Excel Discussion (Misc queries) | |||
| LINEST maximum number of predictor variables | Excel Worksheet Functions | |||
| Index Match With 3 Variables | Excel Worksheet Functions | |||
Threaded Mode
