Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format new Lines into Columns
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 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?? -- efenili ------------------------------------------------------------------------ efenili's Profile: http://www.excelforum.com/member.php...o&userid=32053 View this thread: http://www.excelforum.com/showthread...hreadid=542585 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format new Lines into Columns
No, but you can import the data into excel via dataimport external datanew
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 "efenili" wrote: 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 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?? -- efenili ------------------------------------------------------------------------ efenili's Profile: http://www.excelforum.com/member.php...o&userid=32053 View this thread: http://www.excelforum.com/showthread...hreadid=542585 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
How do I format 1 column of alphabetical listings into 3 columns? | Excel Worksheet Functions | |||
Format columns if data in Col A | Excel Discussion (Misc queries) | |||
format columns to collapse and expand in excel | Excel Discussion (Misc queries) | |||
Both columns change when I format only one column (A) | New Users to Excel |