ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting Contacts list to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/198456-exporting-contacts-list-excel.html)

RichDT

Exporting Contacts list to Excel
 
I've got a 3 column list of over 100 contacts looking like this:

Jim Sullivan
XYZ Company
1400 Penn Ave
Great Lakes, IL 60666
(555) 123-4567; Fax: (555) 890-1234


I want to export to excel w/ columns like Name, company, addr1, addr2, city,
state zip, phone, fax, e-mail. Can't figure out how to do it without
reentering or a lot of cut and paste. Can anyone point me in the right
direction?

Thanks,

--
RDT

Ed Ferrero[_2_]

Exporting Contacts list to Excel
 
Hi RDT,

Go here, http://edferrero.com/ExcelCharts/tabid/102/Default.aspx
download the 'Importing ERP data' sample.

Ed Ferrero
www.edferrero.com

RichDT

Exporting Contacts list to Excel
 
Worked just fine. Thank you very much.
--
RDT


"Ed Ferrero" wrote:

Hi RDT,

Go here, http://edferrero.com/ExcelCharts/tabid/102/Default.aspx
download the 'Importing ERP data' sample.

Ed Ferrero
www.edferrero.com



All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com