Importing long addresses into Quickbooks?

Hello, I've got a list of names and addresses that are each on one line in Microsoft Excel (Sample 1). I'd like to import them into Quickbooks but I get the following error "This field contains more text than is allowed". I've also noticed that Quickbooks will not format the addresses in the billing and shipping boxes (Sample 2). Any help would be greatly appreciated. Thanks everyone. Brian

(Sample 1) Al Schmiz 12021 Sea Breeze Coye Ln #209 Ft. Myers, FL 33908 Al Weme 3450 Latdka Bay Road S.W. Alexandria, Mn 56308

(Sample 2) Al Schmiz

12021 Sea Breeze Coye Ln #209 Ft. Myers, FL 33908

Al Weme

3450 Latdka Bay Road S.W. Alexandria, Mn 56308
Reply to
magiklair
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.