Imagine copying a list of mailing addresses from a website, and pasting them into Excel. You get one column of data.
I need separate columns for Business Name, Address, Phone, Email, Website, etc.
Please answer if you know of free software to do this, or can explain how to do this with Excel, or with maybe a script or MS Access…
Thank you!!!
First you going to have to get the data into a readable format for Excel to be able to import it.
How are you 'copying' the data from the website? Highlight and Ctrl-C? If so then you would want to Save/Paste that data to MSWord or wordpad, but it has to be a 'Special Paste' so that you can select the 'Plain Text' option.
That should get you a text document formatted as 1 line per entry.
You will then SAVE that text file as plain text or a TXT file.
To Import the Text to Excel I suggest to goto the Microsoft website and check out the FREE MS Office Training courses.
Here is the link to the tutorial about importing text to Excel. Enjoy.
http://office.microsoft.com/training/training.aspx?AssetID=RC011801181033
powered by Yahoo Answers