Inserting a carriage return or line feed into data?

  • Thread starter Thread starter AF
  • Start date Start date
A

AF

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 teh 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
 
Hi
try:
=IF(+G115="mail",A115 & CHAR(10) & " attn: " & F115" & CHAR(10) & B115
& CHAR(10) & C115 & CHAR(10) & D115,"")
 
Hi
try:
=IF(+G115="mail",A115 & CHAR(10) & " attn: " & F115" & CHAR(10) & B115
& CHAR(10) & C115 & CHAR(10) & D115,"")
Click to expand...


Thanks. Works great.

I did make one little change to place the zip code right after the
state. The change code is :

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

Thanks for your help
 
Back
Top