What is an automated way to convert a list of business mailing adresses into Excel with formatted columns? - list of new business names
Imagine a copy of the list of email addresses from a website and paste it into Excel. You will receive a data column.
I need separate columns for name, address, phone number, email, website, etc.
Please reply if you know a free software to do this or explain how to do this with Excel, or perhaps a script or MS Access to ...
Thank you!
Sunday, January 10, 2010
List Of New Business Names What Is An Automated Way To Convert A List Of Business Mailing Adresses Into Excel With Formatted Columns?
Subscribe to:
Post Comments (Atom)
4 comments:
The first thing that you get the data into a readable format for Excel import.
How did you "copy" data from the website? Highlight and Ctrl-C? If so, then you want to save to integrate the data into MS Word or WordPad, but it must add a "content", so you can select "Plain Text".
You will receive a text document format 1 line for each entry.
Then save the text file, or text TXT file.
To import the text into Excel, you can at the Microsoft site and check the free training on MS Office.
Here is the link for the tutorial for importing text into Excel. Enjoy.
http://office.microsoft.com/training/tra ...
This address is in a standard format (eg, everyone has the same number of row address, e-mail, zip code, telephone number, etc. at home)? It is in every way a single cell?
If the answers to these is yes, then you may be able to "text to use in columns.
Improve your column, then click Data / Text to Columns and select Separate. Please make a selection by clicking the box that separates the fields (comma?) And then to finish.
If the answer is no, then you probably do not have the ability to automatically so. Excel needs a common denominator in the database to share themselves and to organize the text. I did this exercise before, and had to juggle a lot of sorting, filtering, and writing VBA code. Even then it was human intervention and a lot of sorting.
Good luck, not envy your job.
It depends on what is the suffix of the file to convert. I recommend you go to MS Explorer and select the file. For example, if you a CSV suffix, the right mouse button and choose Open with MS Excel. Excel Help is Assitance analysis "of the work that you want
It depends on what is the suffix of the file to convert. I recommend you go to MS Explorer and select the file. For example, if you a CSV suffix, the right mouse button and choose Open with MS Excel. Excel Help is Assitance analysis "of the work that you want
Post a Comment