Avatar of Bill Golden
Bill Golden
Flag for United States of America

asked on 

Merging two working formulas

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
Microsoft Excel

Avatar of undefined
Last Comment
Bill Golden

8/22/2022 - Mon