April 11, 2010

Replace a particular character in a text:

If you would like to replace a character in a text that exists in a particular position, we can do that please have a look at the below formula and example,



In the above example, we have the name “Jase” in the cell A1 and we had replaced the 2nd character with “o” and we convrted the name “Jase” as “Jose”.

No comments:

Post a Comment