Parsing City State and Zip Code

Hi,

State:

Formula:

=MID(E2,FIND(",",E2)+2,2)

Zip:

Formula:

(LEN(E2)-1=FIND(F2,E2),"",MID(E2,FIND(F2,E2)+3,5))