Format new Lines into Columns

E

efenili

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 do

(e-mail address removed)
www.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??
 
G

Guest

No, but you can import the data into excel via data>import external data>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 data


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADDRESS MACRO 2
Create hyperlink in email 1
Transpose multiple Columns to rows 8
Move rows into columns 3
Outlook add-in that captures contacts from email, web page anddocuments and adds them to outlook add 0
Convert rows to Columns 7
Search for rows in one sheet and copy into another sheet based on customer id 1
Filtering an Excel Report 1

Top