Forum Discussion

jess_d's avatar
jess_d
Copper Contributor
May 29, 2019

remove ( )

How do I remove the ( ) with a formula and put the numbers in separate columns?   Sales order price (0.83 ) does not match EDI transmitted price (0.80 )
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
May 29, 2019
To remove the (), you may need this formula in B1:
=—SUBSTITUTE(SUBSTITUTE(A1,”)”,””),”(“,””)
jess_d's avatar
jess_d
Copper Contributor
May 30, 2019

Thanks!Twifoo 

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 30, 2019
    You’re welcome!

Resources