Number of , in a cell

Thread starter Erik R
Start date Nov 16, 2004

E

Erik R

Nov 16, 2004

#1

Is there a smart function to count the number of commas in a cell?

Erik

F

Frank Kabel

Nov 16, 2004

#2

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

Share:

Facebook X Bluesky LinkedIn Reddit Pinterest Tumblr WhatsApp Email Link

Top