I'm converting data from an old SQL back-end that has the Address field containing the street, city, state and zip AND Fields that contain the city, the State and the ZipCodes. I would like to parse out the citystatezip and just have the street address. There is a manual line break between the street and the CityStateZip in the Address field, but I cannot use it effectively. I have been using Edit - Replace to remove the information based on "city,*" but there are a lot of different citys and they are not accurately spelled. Any suggestions?