AccuZIP Users Community Forum Index AccuZIP Users Community
Tech Support, product information, postal news, and everything else concerning AccuZIP, Inc.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

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

 
Post new topic   Reply to topic    AccuZIP Users Community Forum Index -> File Conversions
View previous topic :: View next topic  
Author Message
Eric
Moderator


Joined: 19 Sep 2006
Posts: 1898

PostPosted: Tue Apr 15, 2014 3:26 pm    Post subject: How to fix an Excel file with returns in the address cell Reply with quote

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:



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.



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



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
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    AccuZIP Users Community Forum Index -> File Conversions All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group