By SCSubstitute and Replace in Excel
The Replace formula is used if we want to replace any character by its position. As shown in images below we want to replace element at 6th position.
Substitute formula is used if we want to replace any character by its content. As shown below here we have substituted 2nd dash in cell without space as nothing is mention in second double quotes in substitute formula.
Both are very useful formulas in excel.
Suppose we have Data in Excel as shown below we have to remove last two digits from it then We can use at a place formula with combination with length formula.
=REPLACE(B3,LEN(B3)-2,3,)
