Trying to count the locations in s cell subtracting spaces and commas. My formula isnt working.

ZEBALL07 

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))