As far as I know, this is the right way to use the SUBSTITUTE function, but the formula gives a parse error. What did I do wrong?

CodePudding user response：

use:

=SUBSTITUTE(A33; "1"; )