|
Re: Concatenate Text with soft return
try the following formula:
=SUBSTITUTE(REPT(Sheet2!F6&CHAR(10),LEN(Sheet2!F6)>0)&REPT(Sheet3!F6&CHAR(10),LEN(Sheet3!F6)>0)&" ",CHAR(10)&" ","")
Plz, MENTION about Format result-cells in Wrap text type,
and set autofill for rows' height
Last edited by tigertiger; 07-04-2009 at 01:46 PM.
|