Description

REPLACE is a text function in Excel. Use it to replace one or more character from a text string with different character(s). This function has four arguments all are mandatory,first is old_text from which you want to replace the character(s). Second is start_num the specific position, third is num_chars, number of characters you want to replace and finally new_text, by which you want to replace. Use this function, if you know the position of the character, you want to replace but not sure about the text.

Syntax

REPLACE(old_text, start_num, num_chars, new_text)

Example

  1. REPLACE Excel function replaces the number of character(s) in a text string from a sepecific position with new specified character(s)

0 Comments

By Rajesh K Saraogi

Rajesh is a hardcore finance person with a penchant for latest technology. His passions are latest technology and to improve the productivity with simple, yet powerful software – mainly on Microsoft Excel platform. He is a qualified MCA. Whenever he gets time he loves to blog, to share the knowledge, which is the only thing which increases after sharing!