We have to use nested SUBSTITUTE() methods for multiple replacing of characters.
Example:
SUBSTITUTE(
SUBSTITUTE(
Name,
" ", ""
)
,"-",""
)
In this example, we can remove “-” and space.
We have to use nested SUBSTITUTE() methods for multiple replacing of characters.
Example:
SUBSTITUTE(
SUBSTITUTE(
Name,
" ", ""
)
,"-",""
)
In this example, we can remove “-” and space.