concatenate two text cells with a new line inbetween

[rogerstaff]

Is ther an easy way to use a formula to concatenate two text cells and insert a new line between them.
IE two cells are bert,fred end with
bert
fred

[Aladin Akyurek]

On 2002-09-08 10:11, rogerstaff wrote:
Is ther an easy way to use a formula to concatenate two text cells and insert a new line between them.
IE two cells are bert,fred end with
bert
fred

In C1 enter:

=A1&CHAR(10)&B1

Check Wrap text (for the formula cell) on the Alignment tab under Format|Cells.

[cyberdork33]

In C1 enter:

=A1&CHAR(10)&B1

Check Wrap text (for the formula cell) on the Alignment tab under Format|Cells.

Thank You! This will work well with my macro to link data labels!

[Pecoda]

Thanks...this answer saved me a ton of time this morning!

[Pumba]

Hi there

Does anyone know how to show where the line break occurs in the excel cell. I.e. I want the square symbol which shows where the line break occurs in the excel cell.

Thanks

N