Find Number (1), in like 12,15,31 Ans.should be 3 [Closed]

Report
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
-
Hello,

Find Number (1), in like 12,15,31
Ans.should be 3
Any formula to count number


1 reply

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Pramod, Good morning.

Suppose:
A1 --> 12,15,31
B1 --> =LEN(A1)-LEN(SUBSTITUTE(A1,1,""))

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!