Multi-Substitute formula

TomKelerian
TomKelerian
in Modeling Ideas

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 !

Tom

Comments

Get Started with Idea Exchange


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



Categories