we have a customer list with 10,000 records that needs to be cleaned up.
address data in colums needs to be broken out. (address-city-state-zip). currenlty all combined in one colum..we also need first and last name broken out into seperate coolums.
have a look at the sample data in excel.