Is it possible to "nest" 2 expressions?
I just want to remove "-" and " " from text input. ( Thank you all in advance for you time )
Example :
Input - abc e-123456 7 Desired result - abce1234567
1.Column Value - Text
2.AND,OR did not work because of YES/NO type.
3.IFS did work half and stop at first expression.
SUBSTITUTE([Input]," ","")
SUBSTITUTE([Input],"-","")
Solved! Go to Solution.
This works, you have to layer the substitutions: SUBSTITUTE(SUBSTITUTE("abc e-123456 7"," ",""),"-","")
This works, you have to layer the substitutions: SUBSTITUTE(SUBSTITUTE("abc e-123456 7"," ",""),"-","")
Thank you.
It works like a charm and save me 20 virtual columns.
I'm really glad it helped!
User | Count |
---|---|
31 | |
13 | |
3 | |
3 | |
2 |