SUBSTITUTE Function
The Excel SUBSTITUTE function is used to replace existing characters with a different set of characters.
The syntax for the SUBSTITUTE function is:
= SUBSTITUTE (text, old text, new_text, [instance_num])
Argument |
Purpose |
|---|---|
Text |
The text or cell reference containing the text with the characters you want to change |
Old_textm |
The existing characters you want to replace. |
New_text |
The new characters to replace the old ones with |
Instance_num |
This argument is optional. It is the number of instances of the old_text that you want to replace If omitted, then every instance of old_text is replaced with the new_text |
The examples below show the SUBSTITUTE function being used change the characters of an existing cell.
Function |
Result |
|---|---|
=SUBSTITUTE(A2,"Solo","Duo") |
Hans Duo |
=SUBSTITUTE(A3,"g","b",1) |
Computerbaga |
=SUBSTITUTE(A3,"g","n") |
Computernana |
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
