Formula for Character-Count


There are several threads:


Look at the reply by Gareth (above) for a solution.


@Justin_Barrett When I tried that I got an error message.


@Kaiti_Hill Looks like the quotes in the version above got mangled somehow. Some are straight, others are curled. Try copying this, which is the fixed version that I tested successfully:

LEN(Name)-LEN(SUBSTITUTE(Name," ","")) + 1
1 Like

@Justin_Barrett you are WONDERFUL. thank you so much!!