A
Alyce
How do you insert a carriage return within an Excel cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Alt + Enter
A
Alyce
I knew there must be a very simple way of doing it. Thanks so much.
J
JudithJubilee
Hello there,
Use Alt + Enter.
Hope this helps
Judith
Use Alt + Enter.
Hope this helps
Judith
R
Rookie_User
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?
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?
R
Roger Govier
Hi
Try
=A1&CHAR(10)&B1
Format the cell with the formula, Format>Cells>Alignment>Wrap text
Try
=A1&CHAR(10)&B1
Format the cell with the formula, Format>Cells>Alignment>Wrap text