SWEEP Make all States two character caps all Contact names to Initial Caps Swap P.O. Box's from Addr1 to Addr3 Split street addresses with SUITE from 1 into 2 Put Mr./Ms. in front of Male/Female names Switch Lastname, Firstname to Firstname Lastname Respell STE. into Suite in Addr1 Swap Suite's from Addr2 to Addr1 Swap Suite's from Addr3 to Addr1 Update Area Code 515 to 641 for S.E. Iowa zipcodes Move street addresses with no Suite/Floor/Room/# from 1 to empty 3 Move street addresses with no Suite/Floor/Room/# from 1 to empty 2 Move street addresses with no Suite/Floor/Room/# from 2 to empty 3 Swap FLOORs from Addr2 to Addr1 when Addr1 doesn't contain Suite/Room/# Swap FLOORs from Addr3 to Addr1 when Addr1 doesn't contain Suite/Room/# Swap P.O. Box's from Addr1 to Addr3 Swap P.O. Box's from Addr2 to Addr3 Swap PO Box's from Addr1 to Addr3 Swap PO Box's from Addr2 to Addr3 Swap POBox's from Addr1 to Addr3 Swap POBox's from Addr2 to Addr3 Swap MS/Mail stops from Addr2 to Addr1 Swap MS (Mail Stops) from Addr3 to Addr2 Swap MS: (Mail Stops) from Addr3 to Addr1 Respell St. into Street in Addr1 (Watch out for Saint) Split street addresses with STE from Addr1 into 2 Split street addresses with STE. from Addr1 into 2 Split street addresses with ROOM from Addr1 into 2 Split street addresses with RM from Addr1 into 2 Split street addresses with # from Addr1 into 2 for longer Addr1's Respell Rd. into Road in Addr1 Left align Addr1 Left align Addr2 Left align Addr3 Split street addresses with RM. from Addr1 into 2 Split street addresses with APT from Addr1 into 2 Split street addresses with APT. from Addr1 into 2 Split street addresses with UNIT from Addr1 into 2 Respell STE into Suite in Addr1 Respell STE into Suite in Addr2 Respell St. into Street in Addr2 Respell Rd. into Road in Addr2 Respell STE into Suite in Addr3 Respell St. into Street in Addr3 Respell Rd. into Road in Addr3 Respell Dr. into Drive in Addr1 Respell Dr. into Drive in Addr2 Respell Dr. into Drive in Addr3 Respell STE into Suite starting Addr1 Respell STE into Suite starting Addr2 Respell STE into Suite starting Addr3 Respell STE. into Suite in Addr1 Respell STE. into Suite in Addr2 Respell STE. into Suite in Addr3 Respell STE. into Suite starting Addr1 Respell STE. into Suite starting Addr2 Respell STE. into Suite starting Addr3