Inserting carriage returns in Excel cells
How do you insert a carriage return within an Excel cell?
|
Alt + Enter
-- Regards, Peo Sjoblom "Alyce" wrote in message ... How do you insert a carriage return within an Excel cell? |
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? |
Hello there,
Use Alt + Enter. Hope this helps Judith -----Original Message----- How do you insert a carriage return within an Excel cell? . |
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? |
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? |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com