Character counting with conditions

Topic Labels: Formulas
2548 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast
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.
3 Replies 3

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

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

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

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