SUBSTITUTE Vs. REPLACE

[LearnMeExcel]

Hi all
is this twoo functions same
what is the difference between it

 

[VoG]

No they are different. Take a look at the Help. Here's an example

Excel Workbook
	A	B
1	LearnMeExcel	Learn**Excel
2	LearnMeExcel	LearnM*Excel
Sheet2

 

[Aladin Akyurek]

Hi all
is this twoo functions same
what is the difference between it

Equivalence in behavior:

A2: vesteTa


B2:

=SUBSTITUTE(A2,"t","X",1)


C2:

=REPLACE(A2,FIND("t",A2),1,"X")

 

[Scott Huish]

From the help file:

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

Excel Workbook
	A	B	C
1		SUBSTITUTE	REPLACE
2	The quick brown fox	The quick brown dog	The quick brown dog
Sheet1

 

[MrKowz]

Substitute is really handy for replacing a specific (or all) instances of a specific character (or string), without knowing the specific location of what you are substituting.

Replace is handy for replacing a specific chunk of a string (ie, you need to know the location of what you are replacing).