REPLACE Function Explained
The REPLACE function in Microsoft Excel allows users to replace characters within a text string. It takes three arguments: old_text, start_num, and num_chars. old_text is the text string to be modified, start_num is the position of the character in the string to be replaced, and num_chars is the number of characters to be replaced. The function returns a new text string with the specified characters replaced.
REPLACE Function Syntax
REPLACE(old_text, start_num, num_chars, new_text)
- old_text: The text string that contains the characters you want to replace.
- start_num: The position of the character in old_text that you want to replace with new_text.
- num_chars: The number of characters in old_text that you want to replace.
- new_text: The new text that will replace the characters in old_text.