remove ( )

Copper Contributor

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 )

3 Replies
To remove the (), you may need this formula in B1:
=—SUBSTITUTE(SUBSTITUTE(A1,”)”,””),”(“,””)

Thanks!@Twifoo 

You’re welcome!