Search for a word in a column and extract the word

Well here's a slightly different approach. I've put your keywords in row 1 of different columns, starting with C, and then put this formula in C2:

Formula:

=(LEN($A2)-LEN(SUBSTITUTE($A2,C$1,"")))/LEN(C$1)

which can then be copied across and down to suit. This will give you a count of the number of times each keyword can be found in the text in column A.

Hope this helps.

Pete

That's perfect, thanks a ton man, brilliant stuff!

Cheers