Quote Originally Posted by sigdig
Sorry for the double post.

If I use the =Left(A1,4)&Right(A1,4), shouldn't the LEFT be 5?
The ZIP exp; 02771-1234 should the formula be =Left(A1,5)&Right(A1,4)?
Aaha - now we find the format of a zip - (it was omitted on your post, and the Zip+4 and 8 characters suggested a 4 character zip)

Yes, adjust the Left-Right to suit, but that will give nine characters.

---