How to fix an Excel file with returns in the address cell

When you have a file that you can't open in AccuZIP6, this forum may help

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1898
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

How to fix an Excel file with returns in the address cell

Post by Eric » Tue Apr 15, 2014 8:26 am

To fix your excel file, 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 add a new column after the final field in your list, and fill that field with five tildes (~~~~~) like this:

Image

Save the file as text (tab delimited).

Open the text file in Word.
Pull down the File menu to Save As. Choose Plain Text.
Choose MS-DOS encoding. Hit Save. Close the file.
Open the text file again in Word.
In Word, replace a return (^p) with a space. Click Replace All.

Image

Finally, replace ~~~~~ with a return (^p)

Image

Close the file and click Yes to save the changes.

Now that text file can be opened in AccuZIP6 with File > Open List.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply