Excel Function : REPLACE – REPLACEB

Download now!

Excel Function : REPLACE – REPLACEB

Category

Text

Description

Replaces characters within text

Microsoft Excel Reference Page

https://support.office.com/en-us/article/REPLACE-REPLACEB-functions-8d799074-2425-4a8a-84bc-82472868878a

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.