now browsing by tag
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:
- Substitute last occurrence only
- Extract partial string after last delimiter
- Extract item from delimited text, based on item position