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