Inserting carriage returns or line feeds into data destined for MS Word.
 

I am new to Excel and can not figure out how to insert a carriage
return or line feed into my data.

here is the formula I am currently using in a cell:

=IF(+G115="mail",CONCATENATE(A115," attn: ",F115," ",B115," ",C115,"
",D115),"")


Here is the resultant data as copied into Word

A FLOWERTIME INC attn: Tom Smith* 1111 GUNN HWY # A* TAMPA, FL 33625*


What I would like to see is this

A FLOWERTIME INC
attn: Tom Smith*
1111 GUNN HWY # A*
TAMPA, FL 33625*


How do I get carriage returns or line feeds into the formula?

Thanks

ps. Is there a better way to get data into Word? Currently I copy
and past the above field into a Word doc. Is there some better
automated way to get data into Word? I am using Excel 2002 by the
way.

thanks

Inserting carriage returns or line feeds into data destined for MS Word.
 

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"AF" schrieb im Newsbeitrag
...
I am new to Excel and can not figure out how to insert a carriage
return or line feed into my data.

here is the formula I am currently using in a cell:

=IF(+G115="mail",CONCATENATE(A115," attn: ",F115," ",B115," ",C115,"
",D115),"")


Here is the resultant data as copied into Word

A FLOWERTIME INC attn: Tom Smith 1111 GUNN HWY # A TAMPA, FL 33625


What I would like to see is this

A FLOWERTIME INC
attn: Tom Smith
1111 GUNN HWY # A
TAMPA, FL 33625


How do I get carriage returns or line feeds into the formula?

Thanks

ps. Is there a better way to get data into Word? Currently I copy
and past the above field into a Word doc. Is there some better
automated way to get data into Word? I am using Excel 2002 by the
way.

thanks