| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to delete blank rows and move data/info
I have an address list that I want to import into an address list mgmt
program. need to get it into excel first including name, address, city, ste zip in separate colums. Sample below (made up names): WAYNE TREDING PO BOX 212 AVONDALE ESTATE GA 30002 0736 TONEY SANDRUFF P O BOX 216755 MARIETTA GA 30006 0016 ROSELEA HOMESLEY 14 LAKESIDE LANE PALM COAST FL 32164 Need to be: WAYNE TREDING PO BOX 212 AVONDALE ESTATE GA 30002 0736 TONEY SANDRUFF P O BOX 216755 MARIETTA GA 30006 0016 ROSELEA HOMESLEY 14 LAKESIDE LANE PALM COAST FL 32164 I can deal with the extra spaces between first and last name, unless it's an easy fix. -- Tx, Samoan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete blank rows in a data range | Excel Discussion (Misc queries) | |||
| reformating data- how to delete alternate blank rows quickly | Excel Discussion (Misc queries) | |||
| How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
| Macro to delete rows with same data | Excel Worksheet Functions | |||
| Delete blank rows Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
