REPLACEB Function Explained
The REPLACEB Function in Microsoft Excel replaces part of a text string, based on the number of characters you specify, with a different text string. It takes three arguments: old_text, start_num, and num_chars. old_text is the text string that contains the characters you want to replace. start_num is the position of the character in old_text that you want to replace with the new text string. num_chars is the number of characters you want to replace.
REPLACEB Function Syntax
REPLACEB(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 first character you want to replace.
- num_chars: The number of characters you want to replace.
- new_text: The text string that will replace characters in old_text.