jess_dCopper ContributorMay 29, 2019remove ( ) 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 )
TwifooSilver ContributorMay 29, 2019To remove the (), you may need this formula in B1:=—SUBSTITUTE(SUBSTITUTE(A1,”)”,””),”(“,””)
