LEN function: Basic and Advanced Examples

LEN function type: Text
Description: Returns the number of characters in a text string
LEN is a basic function widely used, many formulas built for text processing will need this function.
Take a look at the advanced applications examples:
Applications:
- Get the text with the lowest length from a column (first match only)
- Count how many cells within a range of cells have a text length higher than normal
SUBSTITUTE function: Basic and Advanced Examples
SUBSTITUTE function type: Text
Description: Substitutes the old text with new text in a text string
Beyond its basic use, which is fairly simple, the SUBSTITUTE function can be very useful combined with other functions, to get your desired results.
Take a look at the advanced applications examples:
Applications:
- Substitute last occurrence only
- Extract partial string after last delimiter
- Extract item from delimited text, based on item position