Ooops!
I have one too many char(10)'s :
=C8&CHAR(10)&C9&CHAR(10)&C10&CHAR(10)
Should be:
=C8&CHAR(10)&C9&CHAR(10)&C10
Biff
"Biff" wrote in message
...
Hi!
Try something like this:
Format the cell to wrap text:
=C8&CHAR(10)&C9&CHAR(10)&C10&CHAR(10)
In the above, I'm concatenating cells C8, C9 and C10
Biff
"Dajana" wrote in message
...
I have used the CONCATENATE function and obtained the result I wanted but
not
in the form I need. My results are all joined into one text string
(A,B,C,D)
however they need to be one beneath the other in the same cell:
A
B
C
D
Thank you
|