I have an address spreadsheet that has approximately 7,000 addresses
that appears as follows:

__(A)___(B)_____(C)_____(D)______________(E)_____( F)___(G)
NAME_TITLE__FACILITY_STREET_______CITY/STATE__ZIP___PHONE #
John__Clerk____East___123 Main_______Atlanta, GA__05821__217-555-1111
Mary__Typist___West__2321 South St___Miami, FL___01251__654-555-4544
Fred___Director_South_847 12 Street____Kearny, NJ_98511___362-555-2313

I want to rearrange it to appear as follows:
__(A)_____________(B)____(C)_________(D)__________ (E)

John____________________Clerk____________________2 17-555-1111
123 Main________________ East
Atlanta, GA_______05821

Mary____________________Typist____________________ 654-555-4544
2321 South St____________West
Miami, FL__________01251

Fred____________________Director__________________ 362-555-2313
847 12 Street____________South
Kearny, NJ_________98511


Does anyone have any code that would programmatically rearrange the
spreadsheet as above. Any help would be appreciated.


--
smithbj
------------------------------------------------------------------------
smithbj's Profile: http://www.excelforum.com/member.php...o&userid=36532
View this thread: http://www.excelforum.com/showthread...hreadid=562892