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.
Page 1 / 1
Try using `SUBSTITUTE()` to replace all your commas with empty spaces
SUBSTITUTE({Field}, ",", "")
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
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.