I have the following working formula
=IF($Q$11<>""," "&$Q$11&" ","You must enter a the Company's City and State in Q11!")
Which yields City, State & Zip Code, i.e. New York City, New York 12345
And this formula
=LEFT($Q$11,FIND("",$Q$11,
FIND(", ",$Q$11)+3))
Which yields City and State with no Zip Code, i.e. New York City, New York
I need to combine the second formula with the first formula. A snippet with all pertinent cells is attached.
EE-Snippet-CalcXLM-Report-Zip-Code-.xlsm