Be sure comma is there and in the right place

[daniels012]

Ok in City state and Zip

I must have the comma next to the city.
We should alway be typing 2 letters for the state and numbers after the state.

So can I somehow find the numbers on the right to the left of them will be my 2 letter state than any text before that must have the comma following the last word of the first part of text. And maybe do Data Validation???
We might have:
(the underscore represents an unwanted space)
Conway, TN 12345
Conway_, TN 12345 ' Needs to be validated because of the space
Conway, TN 12345-1234
San Jose, GA 12354
San Jose_, GA 12354 ' Needs to be validated because of the space
Research Triangle Park, NC 12365
Or maybe an omitted comma?
San Jose GA 12354 'Validate because of no comma

Thank You in advance,
Michael

 

[daniels012]

There is no real room in the area. And I dont want to add the state and zip in another area of the sheet. Although this would solve the issue.
I already have a bunch of stuff that uses the worksheet_change so I have to think of something different.

Thank You,
Michael