| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel contact list-going from one row to mult. columns
I have been tasked with putting together a list of a company's distributor using their website. I run a regional search on their website and come up with results, which I then paste into excel. Unfortunately, these all appear in Excel in rows, such as the following format: Smith's Leather 10 Main Street Anytown, USA 01776 Phone: 202-555-1000 Fax: 202-555-1001 Dealer Type: Retailer Brands: Coach, Gucci There is a space between each business's information. To further complicate things, the lengths of the entires vary, as some have email addresses, website URLs, and fas numbers, while others do not. does anyone know of a colution to getting these entries out of the single first column and breaking them up into categorized columns or is this just a massive data entry project? -- GTRich ------------------------------------------------------------------------ GTRich's Profile: http://www.excelforum.com/member.php...o&userid=24025 View this thread: http://www.excelforum.com/showthread...hreadid=376382 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address List in Excel | Excel Discussion (Misc queries) | |||
| How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
| Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
| In Excel, how can I print a long list on 1 page in multiple colum. | Excel Discussion (Misc queries) | |||
| Mailing list in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
