SUBSTITUTE

Description Replaces a specified part of a text string with another text string.

Syntax SUBSTITUTE ( text, old_text, new_text [, instance] )

Argument	Description
text	A text string that contains the text to replace. You can also specify a reference to a cell that contains text.
old_text	The text string to be replaced.
new_text	The replacement text.
[instance]	Optional. Specifies the occurrence of old_text to replace. If this argument is omitted, every instance of old_text is replaced.

Examples This function returns "Second Quarter Results":

SUBSTITUTE("First Quarter Results", "First", "Second")

This function returns "Shipment 45, Bin 52":

SUBSTITUTE("Shipment 45, Bin 45", "45", "52", 2)

See Also REPLACE, TRIM