File Conversion: Remove embedded returns from the Address cell in an Excel file
The instructions in this technote will help you get rid of returns that are embedded in the Address field of an Excel file. Returns that separate the address from the address2 in a single cell will cause AccuZIP6 to see that return as an End-Of-Record delimiter, which could cause the address2 or city/state/zip information to appear in the next record's name field. The instructions below require using Microsoft Word and Microsoft Excel to fix the file prior to opening it in AccuZIP6. You’ll have to export it out of Excel as a tab delimited text file and open that file in Word. You’ll use Word to remove the excess returns.
- Open the file in Excel and press CTRL+A to show all
- Press CTRL+H to perform a Search and Replace
- In the Find What box, type CTRL+J
- In Replace With, press the spacebar
- Click Replace All
- Close the file and click Yes to save the changes.
Now that text file can be opened in AccuZIP6 with File > Open List.
