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

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 29, 2019
    To remove the (), you may need this formula in B1:
    =—SUBSTITUTE(SUBSTITUTE(A1,”)”,””),”(“,””)

Resources