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

Perhaps try it as:
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(10),""),CHAR(13),"" )
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bill" wrote:
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