A1=AAA_BBB_CCC_DDD then in B1:

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

Replace "_" with required character

HTH

"presuming ed" wrote:


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