Address block carriage returns not correct

[Guest]

I am attempting to do a mail merge with the addresses on a spreadsheet
(.csv). When I imported the file into Excel, the little "box" characters are
in the place of the carriage returns. I have tried
=SUBSTITUTE(A1,CHAR(13)&CHAR(10),CHAR(9)) and they will not leave! What am I
doing wrong? Here is a paste of one of the address blocks. (of couse the
"boxes" aren't showing here for you to see).

Thanking anyone in advance for the helping hand.

AALBORG INDUSTRIES
5300 KNOWLEDGE PARKWAY
STE 200
ERIE, PA 16510

 

[Guest]

=SUBSTITUTE(A1,CHAR(13)&CHAR(10),CHAR(9))

Perhaps try it as:
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(10),""),CHAR(13),"")

 

[Guest]

Perfect! Thanks Max!

Perhaps try it as:
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(10),""),CHAR(13),"")

 

[Max]

Good to hear that, Bill !
Thanks for feedback ..