Count within a cell

[presuming ed]

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

[Toppers]

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
>
>

[Bob Phillips]

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

--
HTH

Bob Phillips

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

"presuming ed" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Muhammed Rafeek M]

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

"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
>
>

[presuming ed]

Thanks,

works perfectly!