Sign in to join the conversation:
How can I use substitute to replace not only one but multiple letters?
For eg: -0.-9 I want to get 09 only.
Hi,
Try something like this.
=SUBSTITUTE(SUBSTITUTE(Text@row; "-"; ""); "."; "")
The same version but with the below changes for your and others convenience.
=SUBSTITUTE(SUBSTITUTE(Text@row, "-", ""), ".", "")
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have found the easiest way to nest SUBSTITUTE functions is to build out from the middle instead of trying to work from left to right.
To remove the "-", you would use
=SUBSTITUTE(Text@row, "-", "")
.
To remove the "."
=SUBSTITUTE(Text@row, ".", "")
To nest them, just drop one of the SUBSTITUTE formulas into the Text@row portion of the other.
=SUBSTITUTE(SUBSTITUTE(Text@row, ".", ""), "-", "")
If you then wanted to remove a "?"
=SUBSTITUTE(Text@row, "?", "")
and then just drop that into the Text@row portion again just like the last one.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Text@row, "?", ""), ".", ""), "-", "")
Thank you Guys.
Happy to help!
Let us know how it goes!
I have a form that will be filled out internally. There's a cell labeled "Department" which contains 8 dropdown list values. There's a another cell called "Executives" which are the leaders of these departments. In the form, I'm attempting to do a logic where when you choose a specific "Department", then the cell…
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…
what i can do if all my existing smartsheet gant files can't be open after change my plan to Pro? what could be the reason ?
