View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan
 
Posts: n/a
Default Using concatenate to include a line return

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