Old_text required argument This is the text we wish to replace some characters. The syntax of the REPLACE function REPLACE old_text start_num num_chars new_text old_text is the cell containing the text you want to replace. REPLACE A263M25 This tells Excel to use the value in cell A2 D100-H50-79 count over to the 6th character H and include 3 characters H50.
Replace part of formula in a specific cell range Simply select the cell range press CTRL H to open the Find and Replace dialog box.
REPLACEB replaces part of a text string based on the number of bytes you specify with a different text. REPLACE replaces part of a text string based on the number of characters you specify with a different text string. Formula REPLACE old_text start_num num_chars new_text The REPLACE function uses the following arguments. Let us look at the following example replacing the string quick brown with slow white.