Puzzling - Extract the word with PH- in it, start, middle or end of cell location

Originally Posted by FDibbins

Whats wrong with the formula you have there?
can you show some samples where it doesnt work?

Hi there, the formula works if i manually put the word location in the c column. But i download a new file every day with over 200 lines. If i can figure out a way to automatically determine which word in the cell has the "PH-" value in it, that's perfect.