Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from website to Excel
have data in this format
ALABAMA ARAB, ATHENS, BOAZ, CULLMAN, FORT PAYNE, HUNTSVILLE, HUNTSVILLE NORTH State on one row, then next row is cities separated by commas (,), skip a row next state next row cities and so forth. May be one city upto four lines of cities in some states. Would like to end up with 1 column for each state, with the cities under the state such as Alabama Arab Athens etc any suggestions or is this a big cut and paste nightmare? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Website for Excel | Excel Discussion (Misc queries) | |||
Download excel doc from website, can this be done? | Excel Worksheet Functions | |||
How Do I Copy a Website Page To A Sheet? | Excel Programming | |||
Excel doc on a website | Excel Programming | |||
Launching a website from Excel | Excel Programming |