What is the REPLACE function in Excel?
The REPLACE function is one of the TEXT functions of Excel.
It replaces part of a text string with a different text string.
We can find this function in TEXT category of insert function Tab.
How to use REPLACE function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select TEXT category.
5. Select REPLACE function
6. Then select ok.
7. In the function arguments Tab you will see REPLACE function.
8. Old text is text in which you want to replace some characters.
9. Start num is the position of the character in Old text that you want to replace with New text.
10. Num_chars is the number of characters in Old text that you want to replace.
11. New text is the text that will replace characters in Old text.
12. You will see the results in formula result section.
Examples of REPLACE function in Excel
What is the purpose of REPLACE function?
It replaces part of a text string with a different text string.
What is the Return value of REPLACE function?
It just returns the number.
SEARCH (Find text,Within text,Start num)=numberHow many arguments does REPLACE function have?
SEARCH (Old text,Start num,Num_chars,New text)
REPLACE function has 4 argument.
Old text is text in which you want to replace some characters
Start num is the position of the character in Old text that you want to replace with New text
Num_chars is the number of characters in Old text that you want to replace
New text is the text that will replace characters in Old text
Which version of excel supports REPLACE function?
This function is available for all excel versions (2003-2019)
