SUBSTITUTE()

Description

Replaces existing text with new text in a string.

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