Concatenate

[Crystal]

I want to Concatenate a few sentences from multiple
worksheets to form a paragraph but I would like them to
appear as if each sentence were in its own row instead of
one huge long sentence all the way across the worksheet.
Is it possible to use the enter key in Concatenate
functions? If not is there an alternative to the enter
key? Also does anyone know how to superscript a few
select numbers in the Concatenate function? I can only
get either all superscript or no superscript.
Thanks

 

[Frank Kabel]

Hi
try
=A1 & CHAR(10) & A2 & CHAR(10) & A3
format the resulting cell with 'word wrap'

 

[Crystal]

Thank you so much!

-----Original Message-----
Hi
try
=A1 & CHAR(10) & A2 & CHAR(10) & A3
format the resulting cell with 'word wrap'

--
Regards
Frank Kabel
Frankfurt, Germany

.