SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer VSCode Plugin
Tutorials
SpreadJS Designer Component
SpreadJS Collaboration Server
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
    - ARRAYTOTEXT
    - ASC
    - BAHTTEXT
    - CHAR
    - CLEAN
    - CODE
    - CONCAT
    - CONCATENATE
    - DBCS
    - DOLLAR
    - FIND
    - FINDB
    - FIXED
    - JIS
    - LEFT
    - LEFTB
    - LEN
    - LENB
    - LOWER
    - MID
    - MIDB
    - PROPER
    - REPLACE
    - REPLACEB
    - REPT
    - RIGHT
    - RIGHTB
    - SEARCH
    - SEARCHB
    - SJS.ENDWITH
    - SJS.STARTWITH
    - SUBSTITUTE
    - T
    - TEXT
    - TEXTAFTER
    - TEXTBEFORE
    - TEXTJOIN
    - TEXTSPLIT
    - TRIM
    - UNICHAR
    - UNICODE
    - UPPER
    - VALUE
    - VALUETOTEXT
  - Web Functions
  - RegEx Functions
  - ReportSheet Functions
  - Other Functions
  - What-If Analysis Functions
Import and Export Reference
Events
API Documentation
Release Notes

SUBSTITUTE

This function substitutes a new string for specified characters in an existing string.

Syntax

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

Arguments

This function has these arguments:

Argument	Description
text	String or reference to a cell containing the string in which you want to replace characters
old_text	String to be replaced
new_text	New string to use instead of existing string
instance_num	[Optional] Which occurrence of the existing string to replace; otherwise every occurrence is replaced

Remarks

Use this function to replace specific text with other text. Use the REPLACE function to replace a specific number of characters in a specific location with other characters.

Data Types

Accepts string data for the text , old_piece , and new_piece arguments, and numeric data for the instance argument. Returns string data.

Examples

SUBSTITUTE("Down Trend","Down","Up") gives the result Up Trend

SUBSTITUTE("Feb 1, 1991","1","2", 3) gives the result Feb 1, 1992