| 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
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? |
|
#5
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? |
|
#6
|
|||
|
|||
|
Hello there,
Use Alt + Enter. Hope this helps Judith -----Original 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 | |||
Hybrid Mode
