CamelCase to Camel Case
Here is a good practice for combining functions to get a full smartsheet It basically add a space before any capital letter in a text,...
MID + SEARCH to convert cell to rows
I have been there and done that more than once before This time I had a really large cell, more than 3k characters need to...
Hyperlink usage and HyperlinkOf UDF
The Hyperlink function is really powerful and yet not widely used. You can create a whole navigation system with Hyperlink fx or create a custom jump...