Multi-Substitute formula


Hi everyone,

It could be very nice to have a new formula to allow replacing several values by others instead of only one with the substitute function.

For example, to replace "," by "." and " " by "", the current way is :

SUBSTITUTE(SUBSTITUTE([Text], ",", "."), " ", ".")

The new way could be :

SUBSTITUTES([Text], ",", ".", " ", "")

Have a nice day !



Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!