The cells look like this:'

Carson City, NV 60515
Naperville, IL 60540

I have tried Text-to-Columns, but because of the different text string
as far as the city goes, I am stumped!


---
Message posted from http://www.ExcelForum.com/