This portal is to share my acquired knowledge related to Sql Server. I hope will be helpful for novice and professionals.

Thursday, May 5, 2011

Replace word in Excel using Function

In Excel, the Substitute function replaces a set of characters with another.
The syntax for the Substitute function is:
= Substitute( text, oldtext, newtext, nthappearance )

e.g.

In a word "Rajeev ", we want to replace "ee" with "i" then formula will be :


=SUBSTITUTE(A1,"ee","i")

nth appearance is 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.

No comments: