Glenn! You are a genius and a complete lifesaver!!! With a little tweak, your formula worked!!! Thank you SO VERY much! This is the final formula that I am using:

=SUMPRODUCT((LEN(" "&editeddata!$C$2:$C$1731&" ")-LEN(SUBSTITUTE(UPPER(" "&editeddata!$C$2:$C$1731&" "),UPPER(" "&B2&" "),"")))/LEN(" "&B2&" "))

Where data are in editeddata!$C$2:$C$1731 and the word to look up is in B2. I dragged this formula down and while the B2 changes to B3, B4... like I wanted, I figured out how to insert $ in the data sheet range so the data reference stays the same. Wala!!! It worked!!!!

Thank you thank you thank you again!!!