View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
efenili
 
Posts: n/a
Default 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