Address block carriage returns not correct
 

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

Address block carriage returns not correct
 

=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

Address block carriage returns not correct
 

Perfect! Thanks Max!

"Max" wrote:

=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

Address block carriage returns not correct
 

Good to hear that, Bill !
Thanks for feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bill" wrote in message
...
Perfect! Thanks Max!