Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inserting carriage returns in Excel cells
How do you insert a carriage return within an Excel cell?
|
#2
|
|||
|
|||
Alt + Enter
-- Regards, Peo Sjoblom "Alyce" wrote in message ... How do you insert a carriage return within an Excel cell? |
#3
|
|||
|
|||
I knew there must be a very simple way of doing it. Thanks so much.
"Peo Sjoblom" wrote: Alt + Enter -- Regards, Peo Sjoblom "Alyce" wrote in message ... How do you insert a carriage return within an Excel cell? |
#4
|
|||
|
|||
Hello there,
Use Alt + Enter. Hope this helps Judith -----Original Message----- How do you insert a carriage return within an Excel cell? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting carriage returns in Excel cells
How might one do this electronically -- lets say you want to add two columns
together into a third column - but rather than concatenate into one string they need to appear in the third column as the following. col1 col2 col3 A B A B Any idea's? "Alyce" wrote: I knew there must be a very simple way of doing it. Thanks so much. "Peo Sjoblom" wrote: Alt + Enter -- Regards, Peo Sjoblom "Alyce" wrote in message ... How do you insert a carriage return within an Excel cell? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting carriage returns in Excel cells
Hi
Try =A1&CHAR(10)&B1 Format the cell with the formula, FormatCellsAlignmentWrap text -- Regards Roger Govier "Rookie_User" wrote in message ... How might one do this electronically -- lets say you want to add two columns together into a third column - but rather than concatenate into one string they need to appear in the third column as the following. col1 col2 col3 A B A B Any idea's? "Alyce" wrote: I knew there must be a very simple way of doing it. Thanks so much. "Peo Sjoblom" wrote: Alt + Enter -- Regards, Peo Sjoblom "Alyce" wrote in message ... How do you insert a carriage return within an Excel cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions | |||
Excel Charts and cells | Charts and Charting in Excel |