Excel Function

REPLACE

Replaces part of text based on position.

REPLACE(old_text, start_num, num_chars, new_text)

Arguments

old_text

Required

Enter a text value (wrap with quotes when needed).

start_num

Required

Enter a numeric value.

num_chars

Required

Enter a numeric value.

new_text

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

format and display text values. Use REPLACE to Replaces part of text based on position. use B2 for old_text, use 1 for start_num, use 2 for num_chars, use "XX" for new_text. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=REPLACE(B2, 1, 2, "XX")

Practice This Function

Practice in Sequential Mode Back to Function List