count the occurence of a character in a cell

[GN0001]

Hello,

Does anybody know how to count the occurrence of a specific character in a cell?

I have a cell contains: 123, 2224,555

I need to put a function that counts the number of "," in a cell?

Regards,

GN

 

[SirJB7]

Hi, GGGGG!

Try this:

=LARGO(A1)-LARGO(SUSTITUIR(A1;",";""))

in english: =LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

Regards!

 

[GN0001]

Hello, Thank you for the response.

Do we have a built in function in Excel for this purpose?

Regards,

GGGGG

 

[SirJB7]

Hi, GGGGG!

No, there is not such a built-in function.

Regards!

 

[GN0001]

thanks for the help. GGGGG

 

[SirJB7]

Hi, GGGGG!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!

 

[GN0001]

SirJB7 I should thank you more. GGGGG