Hi,

Am Sat, 20 Oct 2012 07:11:50 +0000 schrieb tamer:

i need to count how many times a word is in string in the same cell

your string in A1, the word you search in B1:
=SUM((LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),LOWER(B1),"")))/LEN(B1))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2