Menu
EXCEL REPLACE FUNCTION
Excel REPLACE Function Introduction
This method replaces text depending on its position and returns the resulting text.
Description of Excel REPLACE Function
Syntax:
=REPLACE (old_text, start_num, num_chars, new_text)
Parameter list:
- old text – The text that should be replaced.
- start_num – The beginning point for the search in the text.
- num_chars -The amount of characters to replace is specified by num chars.
- new_text – The new text that will replace old text.
Step By Step Guide of REPLACE Function
Example :
Key Points
- When you wish to replace text in a string depending on its position, use the REPLACE function.
- If the position of the text to be replaced is unknown, use Discover or SEARCH to find it.
- SUBSTITUTE can be used to replace text depending on its content.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
