Change to SUBSTITUTE() Function

The SUBSTITUTE() function was not able to substitute null values.

For example, this formula, a common way to count words, did not work:

 IF({Text}, LEN(TRIM({Text})) - LEN(SUBSTITUTE(TRIM({Text}), " ", "")) + 1, 0)

This is no longer true. You can now use SUBSTITUTE() to remove text from a string! The formula above now works!!


Jim - Subscribe to The Monday Man
Watch Our Latest Video: The Power of the Right-Click

1 Like