Character counting with conditions

[IIAL]

I am using the LEN(string) function but I want it to exclude commas, is there a way to do that? I have a list of items with commas in between, I would like a character count of the letters but not the commas.

[TheTimeSavingCo]

Try using `SUBSTITUTE()` to replace all your commas with empty spaces

SUBSTITUTE({Field}, ",", "")

[IIAL]

I would like to keep the commas, but not have them count towards character count

[TheTimeSavingCo]

Ah I'm confused sorry.  Could you tell me what problem you're encountering with my suggestion above? 

If you could include a screenshot of the issue you're facing that'd be great too.  Once I understand what the problem is I can provide advice on how to fix it