Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Character counting with conditions

2530 0
cancel
Showing results for 
Search instead for 
Did you mean: 
IIAL
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