How to change text string?

D

Dajana

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
 
B

Biff

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
 
B

Biff

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
 
Top