SUBSTITUTE replaces part of a text string, based on the characters you specify, with a different text string. This function is categorized as a String/Text Function. In this video we described how to use SUBSTITUTE function in different situations.
Tag: replacing characters
REPLACE function in Excel
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. This function is categorized as a String/Text Function. In this video we described how to use REPLACE function in different situations.