Using concatenate to include a line return

[dan]

I have a string of text in one cell and another string in a different cell.
I'd like to use the concatenate worksheet function to have them in a single
cell seperate by a line return. This then repeats down the columns.

e.g. A B C (what I'd like)

1 ABC DEF ABC
DEF
2 GHI JKL GHI
JKL

Does anyone know how I can insert a line return "character / symbol" into
the concatenate worksheet function to make this work or alternatively can
anyone suggest another way of doing this???

Thanks in advance all you lovely people....

[CLR]

CHAR(10) is the symbol for the in-cell Carraige Return.

=A1&CHAR(10)&B1 will return the concatenated values of A1 and B1 in a
single line, separated by a little square symbol. If you then re-format the
cell, Right-click > FormatCells > AlignmentTab > check the WrapText box, then
the in-cell Carraige Returns will take affect and the row will automatically
resize.

hth
Vaya con Dios,
Chuck, CABGx3



"dan" wrote:

> I have a string of text in one cell and another string in a different cell.
> I'd like to use the concatenate worksheet function to have them in a single
> cell seperate by a line return. This then repeats down the columns.
>
> e.g. A B C (what I'd like)
>
> 1 ABC DEF ABC
> DEF
> 2 GHI JKL GHI
> JKL
>
> Does anyone know how I can insert a line return "character / symbol" into
> the concatenate worksheet function to make this work or alternatively can
> anyone suggest another way of doing this???
>
> Thanks in advance all you lovely people....
>

[CLR]

CHAR(10) is the symbol for the in-cell Carraige Return.

=A1&CHAR(10)&B1 will return the concatenated values of A1 and B1 in a
single line, separated by a little square symbol. If you then re-format the
cell, Right-click > FormatCells > AlignmentTab > check the WrapText box, then
the in-cell Carraige Returns will take affect and the row will automatically
resize.

hth
Vaya con Dios,
Chuck, CABGx3



"dan" wrote:

> I have a string of text in one cell and another string in a different cell.
> I'd like to use the concatenate worksheet function to have them in a single
> cell seperate by a line return. This then repeats down the columns.
>
> e.g. A B C (what I'd like)
>
> 1 ABC DEF ABC
> DEF
> 2 GHI JKL GHI
> JKL
>
> Does anyone know how I can insert a line return "character / symbol" into
> the concatenate worksheet function to make this work or alternatively can
> anyone suggest another way of doing this???
>
> Thanks in advance all you lovely people....
>