[PrintOwners] Converting Excel Addresses to Delimited Format

[Steve Blatman]

If each address is in one row, with name, address, etc. in successive 
columns, you should be able to save the Excel file as a csv (comma 
delimited) file. That's usually the way we get lists to process or 
print. If each address is in three successive rows in the same 
column, then you have to get fancier. It wouldn't be too hard to do 
it as a couple of macros in Word or Wordperfect, but it wouldn't be a 
matter of simply saving the file as a csv.

HTH,
Steve


> 
> We received an Excel file with addresses in label format (name, address,
> city stacked in cells A1, B1, C1, another name in A2, B2, C2, etc.). Is
> there a way to convert the file to a delimited text file? We just need to
> print the addresses onto envelopes; can we do that as it is set up now?
> Thanks.
> 
> Andy Flamm
> 
> -- 
> Cedar Business Center--Printing, Mailing & More Since 1983
> 345 Cedar Street, Suite 256
> Saint Paul, Minnesota 55101
> 
> 651-293-3904 voice
> 651-293-3905 fax
> 
> andy at CedarBusinessCenter.com
> www.CedarBusinessCenter.com
> _______________________________________________
> PrintOwners Discussion List
> Post: PrintOwners at printweb.org
> Info: http://rb.enter.net/mailman/listinfo/printowners
> 
> 
> __________ NOD32 2713 (20071210) Information __________
> 
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
> 
> 

Steve Blatman
Ink Spot Printing & Copy Center, Inc.
14 Church Road, Frazer, PA 19355 USA
Tel: 610-647-0776
Fax: 610-647-4560