Home

remove ( )

%3CLINGO-SUB%20id%3D%22lingo-sub-656374%22%20slang%3D%22en-US%22%3Eremove%20(%20)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656374%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20remove%20the%20(%20)%20with%20a%20formula%20and%20put%20the%20numbers%20in%20separate%20columns%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ESales%20order%20price%20(0.83%20)%20does%20not%20match%20EDI%20transmitted%20price%20(0.80%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-656374%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-656569%22%20slang%3D%22en-US%22%3ERe%3A%20remove%20(%20)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-656569%22%20slang%3D%22en-US%22%3ETo%20remove%20the%20()%2C%20you%20may%20need%20this%20formula%20in%20B1%3A%3CBR%20%2F%3E%3D%E2%80%94SUBSTITUTE(SUBSTITUTE(A1%2C%E2%80%9D)%E2%80%9D%2C%E2%80%9D%E2%80%9D)%2C%E2%80%9D(%E2%80%9C%2C%E2%80%9D%E2%80%9D)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-658319%22%20slang%3D%22en-US%22%3ERe%3A%20remove%20(%20)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658319%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-658340%22%20slang%3D%22en-US%22%3ERe%3A%20remove%20(%20)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658340%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome!%3C%2FLINGO-BODY%3E
jess_d
New 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!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies