Home

Splitting data

%3CLINGO-SUB%20id%3D%22lingo-sub-583124%22%20slang%3D%22en-US%22%3ESplitting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583124%22%20slang%3D%22en-US%22%3E%3CP%3EI%20receive%20data%20in%20the%20following%20format%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EC-3.00D-3.00P-0.00O-0.00(T-3.00)%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Eand%20only%20need%20T-3.00.%26nbsp%3B%20How%20do%20I%20get%20rid%20off%20the%20unwanted%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583124%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583161%22%20slang%3D%22en-US%22%3ERe%3A%20Splitting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583161%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344060%22%20target%3D%22_blank%22%3E%40larrymcfarland%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20extract%20what%20is%20in%20brackets%20by%3C%2FP%3E%0A%3CPRE%3E%3DMID(A1%2CSEARCH(%22(%22%2CA1)%2B1%2CLEN(A1)-SEARCH(%22(%22%2CA1)-1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583171%22%20slang%3D%22en-US%22%3ERe%3A%20Splitting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583171%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Sergei.%26nbsp%3B%20That%20is%20exactly%20what%20I%20needed.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583268%22%20slang%3D%22en-US%22%3ERe%3A%20Splitting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344060%22%20target%3D%22_blank%22%3E%40larrymcfarland%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
larrymcfarland
New Contributor

I receive data in the following format 

C-3.00D-3.00P-0.00O-0.00(T-3.00)

and only need T-3.00.  How do I get rid off the unwanted data?

3 Replies

@larrymcfarland , you may extract what is in brackets by

=MID(A1,SEARCH("(",A1)+1,LEN(A1)-SEARCH("(",A1)-1)

Thank you Sergei.  That is exactly what I needed. @Sergei Baklan 

@larrymcfarland , you are welcome