Excel Function

SUBSTITUTE

Substitutes occurrences of text with new text.

SUBSTITUTE(text, old_text, new_text, [instance_num])

Arguments

text

Required

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

old_text

Required

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

new_text

Required

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

instance_num

Optional

Enter a numeric value.

Practice Preview

format and display text values. Use SUBSTITUTE to Substitutes occurrences of text with new text. use B2 for text, use " " for old_text, use "" for new_text, use 1 for instance_num. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=SUBSTITUTE(B2, " ", "", 1)

Practice This Function

Practice in Sequential Mode Back to Function List