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!!
YAY!
Jim - Subscribe to The Monday Man
Watch Our Latest Video: The Power of the Right-Click