What is the use of REPLACE function?
REPLACE function replaces a sequence of characters/words in a string with another set of characters/words
What is the syntax of REPLACE function?
old_text: actual string value
start_num: position in old_text to begin replacing characters
num_chars: number of characters to replace in old_text
new_text: replacement set of characters
REPLACE Function in Excel – Examples
Please refer the below article for more Text Excel functions.
Text Excel Formulas
Please refer the below article for more Excel Functions.
Excel Formulas | Home