Dave,

No problem at all, I don't have access to the spreadsheets as I am at home,
but I badly need an answer to this...They do appear exactly as I said
before...For instance...

D2 may contain Indianapolis, IN 46207
D3 may contain Dallas, TX 75204-1545
D4 may contain Rockford, IL 611071735

So, as you can see, the city will contain varying numbers of characters, and
so will the zip code...the zip code may also contain the "-", but most of the
time will not.

Is there a way for Excel to look for the first number in the cell, count 5
numbers, then truncate the rest? Seems like the only logical way for
me...Anything you can provide will be greatly appreciated!

Thanks again!
Tom

"Dave" wrote:

Hi, sorry to be pedantic. Does it really have a comma and a space after the
city?
Please post a sample of a few CityStateZip cells.
Regards - Dave.