|With your Address in cell P1|
and your two character State Code in cell R1
Find an empty cell and try this:
your address must end with a 5 digit zip
and a 2 character State Code,
and the above should work.
Make life easier on yourself and break up the address.