Below is a proposed solution for the Challenge 66 – Find the Position of Word
Put the following formula and drag down. Let's assume the word "and" in cell D2 –
=LEN(REPLACE(A2,SEARCH(" "&$D$2," "&A2),LEN(A2),""))-LEN(SUBSTITUTE(
REPLACE(A2,SEARCH(" "&$D$2," "&A2),LEN(A2),"")," ",""))+1
You may download the solution workbook – Solution – Challenge 66 – Find the Position of Word