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?