Replaces existing text with new text in a string.
Description
How To Use in Sheets
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
External Links
Count text characters in a string
Google Sheets use Len and Substitute to count comma separated elements in a cell.
1Better Sheets Tutorial