| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate address column to Five columns | Excel Worksheet Functions | |||
| Mail Merge creates a space in the address block | Excel Discussion (Misc queries) | |||
| How do I stop e-mail address from turning into link in Excel? | Excel Discussion (Misc queries) | |||
| ?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
