Menu
EXCEL SUBSTITUTE FUNCTION
Excel SUBSTITUTE Function Introduction
This method will insert new text into the text string in place of the old text that you specify. It’s similar to the Find and Replace function in Excel.
Description of SUBSTITUTE Function Function
Syntax:
=SUBSTITUTE (text, old_text, new_text, [instance])
Parameter list:
- text – The text to be modified.
- old text – The text that should be replaced.
- new_text – The text to be replaced.
- instance – If instance is not given, all occurrences of old text are replaced with new text.
Step By Step Guide of SUBSTITUTE Function
Example :
In the first entry, we changed the name john to vijay.
In the second entry, we perform the same thing, but because the fourth parameter is set to 1, it will only substitute the first occurrence.
Because the SUBSTITUTE function is case sensitive, it will not replace the second occurrence of john in the third item with vijay.
Key Points
SUBSTITUTE is case sensitive and does not support wildcard characters such as? or *.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
