Convert phone directory to an excel spreadsheet

[Robert Sterbenc]

Dear Panel:

I would like to know how to convert a list of phone
book addresses from Switchboard.com to an Excel
spreadsheet, with each address on its own single line.

Thanks

Robert Sterbenc

 

[David McRitchie]

Hi Robert,
See http://www.mvps.org/dmcritchie/excel/snakecols.htm

With a little bit of luck, trial and error, and experience you could
easily find answers in the Google Groups (Newsgroups) Archive
http://www.mvps.org/dmcritchie/excel/xlnews.htm

 

[Gord Dibben]

Robert

Show us an example of what you get when the address list is pasted to an Excel
worksheet.

Gord Dibben Excel MVP

 

[Robert Sterbenc]

-----Original Message-----
Dear Panel:

I would like to know how to convert a list of phone
book addresses from Switchboard.com to an Excel
spreadsheet, with each address on its own single line.

Thanks

Robert Sterbenc



.