combining trim and if formula

I am using a trim formula in excel:

TRIM(LEFT(SUBSTITUTE(MID(M2,FIND("|",SUBSTITUTE(M2,"-","|",2))+1,LEN(M2)),"-",REPT(" ",LEN(M2))),LEN(M2)))

this looks for a number in between a string of 4 numbers:

193449542-27309370502-9045796-169794419204 

which works perfectly.

I want to add an if= when a another cell on that same row contains either "bing" or "Adwords" and skip cells that contain it.

I can't seem to find out how that works, any ideas would be hugely appreciated.