Try

=(LEN(A1)-LEN(SUBSTITUTE(A1,"school","")))/6

The 6 is the length of the word for which you're searching, if you put
your search word in a cell, say C2

=(LEN(A1)-LEN(SUBSTITUTE(A1,C2,"")))/LEN(C2)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512954