=LEN(A1)-LEN(SUBSTITUTE(A1,"_","")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"presuming ed"
wrote in message
...

Is there any way of performing a count on an individual cell to identify
the number of occurances of a specified character within that cell?

e.g. Cell contains AAA_BBB_CCC_DDD

I would like the number of underscores (3) to be returned and this
value placed in a new cell?

Thanks


--
presuming ed
------------------------------------------------------------------------
presuming ed's Profile:
http://www.excelforum.com/member.php...o&userid=31526
View this thread: http://www.excelforum.com/showthread...hreadid=573700