Combining formula on three conditions

[rex759]

Hello,

I am having trouble combining these two formulas into one. I thought I could use something like this:

=IF(ISERROR(REPLACE(LEFT(A85,FIND(" ",A85,FIND("CAT",A85)+1)-4),1,FIND(" ",A85),"")),REPLACE(LEFT(A85,FIND(" ",A85,FIND("HOUSE",A85)+1)-6),1,FIND(" ",A85),""),REPLACE(LEFT(A85,FIND(" ",A85,FIND("CAT",A85)+1)-4),1,FIND(" ",A85),""))

But when I do, it only works correctly when the string “CAT” is found. There are three options:
If A85 has Cat, House, or neither.

Any help is appreciated

 

[rex759]

Wow, you saved me again. Works perfectly. Thank you

 

[Fluff]

Glad to help & thanks for the feedback.