Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

SUBSTITUTE

Description: Substitutes New_text for Old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

Syntax: SUBSTITUTE(Text, Old_text, New_text, [Instance_num])

Example:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.