Forum Discussion
ZEBALL07
Feb 13, 2024Copper Contributor
Trying to count the locations in s cell subtracting spaces and commas. My formula isnt working.
Trying to count the locations in s cell subtracting spaces and commas. My formula isnt working. Below is the formula I am trying to use along with an example of the cell I am trying to count. =L...
Patrick2788
Feb 13, 2024Silver Contributor
Your formula works for me. Although, the text in your post is displaying a different kind of "" from what Excel is looking for with the syntax.
Working formula:
=LEN(D2)-LEN(SUBSTITUTE(D2,",",""))+1
Another approach using 365 functions:
=LET(terms, TEXTSPLIT(D2, ", "), COUNTA(terms))