Problem with Addresses
I have to input an entire phone book of addresses. I have since manually
typed 1175 but this is extremely time consuming and there is no end in site. Luckily, the phone book is posted on a website so I can cut and paste the entires However the entries appear on the website like this: Albis Turlington Architects, LLC Phone: 203-772-1212 175 Orange Street Fax: 203-773-1212 New Haven, CT 06510 when pasted into excel they appear in the same manner, each line in a different cell, phone and fax are in their own cells as well. The formatting of my spreadsheet has 6 different columns. 1 for the first line, 1 for the second, 1 for town and state, 1 for zip code, 1 for phone number, and 1 for fax. How can I get the data to paste in my spreadsheet format? |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com