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
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.