Last Updated: 18 Jun 2019 09:30 by Steven
Created on: 18 Jun 2019 09:30
Category: Spreadsheet
Type: Bug Report
Spreadsheet formula SUBSTITUTE does not replace all occurrences of a string with an empty string

Bug report

When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.

Reproduction of the problem

  1. Go to Spreadsheet Basic usage demo
  2. Add a new sheet
  3. Type ab113abababab11ab in A1
  4. Enter the following formula in B1 =SUBSTITUTE(A1, "ab", "")

NOTE: substituting ab with another string, e.g. cd, replaces all instances of ab as expected.

Current behavior

113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string

Expected/desired behavior



  • Kendo UI version: 2019.2.514
  • Browser: all