SUBSTITUTE

Returns a modification of the specified text where all occurrences of a text are replaced with another text.

Syntax

SUBSTITUTE( Text text, Text old, Text new, [Integer which] ) → Text

Parameters

text

Required. The input text.

old

Required. The text to replace.

new

Required. The text to replace with.

which

Optional. Specifies (if not omitted) which occurrence to replace.

Remarks

If which is omitted every occurrence of old is substituted. If which is less than or equal to 0, the function returns the #VALUE! error value. If which is not integer, it is automatically truncated.

If there is no match, or if old has zero length, the value of text is returned unchanged.

Example

Formula

=SUBSTITUTE(A2,"Sales","Cost")

See Also

Function Reference
LEFT Function
LEN Function
MID Function
REPLACE Function
RIGHT Function