Snasui Excel Forum

Posted: **Fri Feb 18, 2022 1:16 pm**

Hi there,

How are you?hope you're all well.

I need a formula to count phone number in a single cell.

I attached a sample template as well.

TY

Posted: **Fri Feb 18, 2022 1:57 pm**

...

B2
=LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))+1

Norkaz

Posted: **Fri Feb 18, 2022 5:22 pm**

Count phone number