Multiple formulas in one cell

[spencerb]

I have multiple formulas that I need to run in one cell. I need to run them in the following order -

In cell C2 -
The 1st formula is: =SUBSTITUTE(H2,", United States","")
The 2nd formula is: =LEFT(H2,FIND(CHAR(1),SUBSTITUTE(H2,",",CHAR(1),LEN(H2)-LEN(SUBSTITUTE(H2,",",""))))-1)

I can't seem to find a way to run both formulas in the same cell. They have to be run in that order or the result will not be correct sometimes. I am trying to remove ", United States" so the second formula will work correctly and remove the city, state, and zip.

The final result should look like this:

I can accomplish this with the two formulas in seperate columns, but it would be much cleaner if it was all in one column.

Thank you,
Spencer

 

[spencerb]

@Sufiyan97 - That works too! Looks like there are many ways to skin this cat...

Thank you again!