Text expression (Nested?)

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 Solved
0 3 129
1 ACCEPTED SOLUTION

This works, you have to layer the substitutions: SUBSTITUTE(SUBSTITUTE("abc e-123456 7"," ",""),"-","")

DayToDataInc_0-1726498822465.png

 

View solution in original post

3 REPLIES 3

This works, you have to layer the substitutions: SUBSTITUTE(SUBSTITUTE("abc e-123456 7"," ",""),"-","")

DayToDataInc_0-1726498822465.png

 

Thank you.
It works like a charm and save me 20 virtual columns.

I'm really glad it helped!

Top Labels in this Space