View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
samoan samoan is offline
external usenet poster
 
Posts: 7
Default 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