Then cut and paste it all back into excel.<BR><BR>Alternatively you can get the zipcode/city/sate database, import it into excel, and then use vlookup statements to pull the city/state for each ...