Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

SUBSTITUTE Formula

SUBSTITUTE formula is used to replace character/text with another character/text. 

Syntax for SUBSTITUTE formula

SUBSTITUTE (text, old_text, new_text, [instance_num])

Parameters Details:

• text: The original string to use to perform the substitution.

• old_text : The existing characters to replace.

• new_text :  The new characters to replace old_text with.

• instance_num : Optional. It is the nth appearance of old_text that you wish to replace. If this parameter is omitted, then every occurrence of old_text will be replaced with new_text.

Returns

The SUBSTITUTE function returns a string/text value.