REPLACE, REPLACEB function
Summary
Replaces characters within text
Syntax
REPLACE(old_text, start_num, num_chars, new_text)
The REPLACE function syntax has the following arguments:
• Old_text Required. Text in which you want to replace some characters.
• Start_num Required. The position of the character in old_text that you want to replace with new_text.
• Num_chars Required. The number of characters in old_text that you want REPLACE to replace with new_text.
• New_text Required. The text that will replace characters in old_text.
• Old_text Required. Text in which you want to replace some characters.
• Start_num Required. The position of the character in old_text that you want to replace with new_text.
• Num_chars Required. The number of characters in old_text that you want REPLACE to replace with new_text.
• New_text Required. The text that will replace characters in old_text.
Example
=REPLACE(A2,6,5,"*")
=REPLACE(A3,3,2,"10")
=REPLACE(A4,1,3,"@")
=REPLACE(A3,3,2,"10")
=REPLACE(A4,1,3,"@")