Using concatenate to include a line return

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
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
 
Back
Top