Jan 05 2018
08:35 AM
- last edited on
Jul 25 2018
10:41 AM
by
TechCommunityAP
Jan 05 2018
08:35 AM
- last edited on
Jul 25 2018
10:41 AM
by
TechCommunityAP
Hello, All!
I'm trying to do a find & replace that would turn this:
someText(25)
into:
25
The 25 could be any number value. Basically, I want to delete "someText(" and the the last parenthesis. Can I use find & replace to do this? Thanks!
Jan 05 2018 09:35 AM
Hi Brian,
can you try this one?
=REPLACE(REPLACE(A1,1,FIND("(",A1),""),FIND(")",REPLACE(A1,1,FIND("(",A1),"")),100,"")
Thanks,
kenkie
Jan 05 2018 10:20 AM - edited Jan 05 2018 10:21 AM
Brian,
If you have Excel 2013 or later then the best way to clean your data is to use the Flash Fill.
For example, imagine that you have some data in range A1:A21 as shown in the below screenshot,
and you want to extract the numbers only, in cell B1 type 82,
then step down to cell B2 and press Ctrl+E.
If you have Excel 2010 or earlier, use this formula:
=SUBSTITUTE(REPLACE(A1,1,SEARCH("(",A1),""),")","")