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 !
Tom
0
Comments
-
I agree that this would be nice…
1
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!