software

Hello.

I have the task of Copying information from a website into an excel
spreadsheet.

The information is listed like this on the website:

*Company Name*
Address
City, State Zip
*Contact:* Persons Name
*Phone:* xxx-xxx-xxxx
*FAX:* xxx-xxx-xxxx
*Toll Free:* xxx-xxx-xxxx
*Description:* Short description of what they dowww.websitehere.com
---------------------------------------------------
My Spreadsheet has each Category in a column...like this:

Name | Address | Contact | Phone | FAX | Toll Free |
Description | Email | Website |

How can i make it so that I only need to copy and paste 1 time and get
the information into the right columns??? Can I do this??--
efenili
------------------------------------------------------------------------
efenili's Profile: www.excelforum.com/member.php...oamp;userid=32053
View this thread: www.excelforum.com/showthread...hreadid=542585No, but you can import the data into excel via datagt;import external datagt;new
web query or you can paste into a text edit and save as a text file, then
open the text file with excel and the text import wzard will let you
configure your imported dataRegards,

Peo Sjoblomquot;efeniliquot; wrote:

gt;
gt; Hello.
gt;
gt; I have the task of Copying information from a website into an excel
gt; spreadsheet.
gt;
gt; The information is listed like this on the website:
gt;
gt; *Company Name*
gt; Address
gt; City, State Zip
gt; *Contact:* Persons Name
gt; *Phone:* xxx-xxx-xxxx
gt; *FAX:* xxx-xxx-xxxx
gt; *Toll Free:* xxx-xxx-xxxx
gt; *Description:* Short description of what they do
gt;
gt;
gt; www.websitehere.com
gt; ---------------------------------------------------
gt; My Spreadsheet has each Category in a column...like this:
gt;
gt; Name | Address | Contact | Phone | FAX | Toll Free |
gt; Description | Email | Website |
gt;
gt; How can i make it so that I only need to copy and paste 1 time and get
gt; the information into the right columns??? Can I do this??
gt;
gt;
gt; --
gt; efenili
gt; ------------------------------------------------------------------------
gt; efenili's Profile: www.excelforum.com/member.php...oamp;userid=32053
gt; View this thread: www.excelforum.com/showthread...hreadid=542585
gt;
gt;