Excel Function : REPLACE – REPLACEB
Replaces characters within text
Microsoft Excel Reference Page
Syntax and Description of the REPLACE – REPLACEB Excel Function
syntax REPLACE(old_text, start_num, num_chars, new_text) REPLACEB(old_text, start_num, num_chars, new_text) &old_text The text string containing the characters to be replaced. &start_num The position of the first character to be replaced in old_text. &num_chars The number of characters in old_text to be replaced. &new_text The new text string to replace the characters in old_text that are specified by start
About REPLACE – REPLACEB Excel Function
Replace function in excel is used to replace a set of characters in a string with another set of characters. ReplaceB function in excel is used to replace a set of characters in a binary string with another set of characters.