I have a table with the text field "keyword". In my form I have a calculated field called "NumberOfChars", which contains the formula "=LEN([keyword])". This works perfectly, but I really want the result to be the number of characters less any spaces. For example, if the keyword is "New Jersey", the NumberOfChars result should read "9" and not "10".
Is there a way of doing this within the LEN formula? I have tried various Excel-type formulas, but get error results for each one.
I would be happy to create another field that copies the keyword and strips out the spaces (and then using the LEN formula to count this), but I can't work out how to do that either.
Any help on working round this problem would be very much appreciated.
Is there a way of doing this within the LEN formula? I have tried various Excel-type formulas, but get error results for each one.
I would be happy to create another field that copies the keyword and strips out the spaces (and then using the LEN formula to count this), but I can't work out how to do that either.
Any help on working round this problem would be very much appreciated.