Forum Discussion

Brian Jarvis's avatar
Brian Jarvis
Copper Contributor
Jan 05, 2018

Find and replace? Delete some characters but leave others?

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...
Formulas & Functions
Need Help
Kenneth Reyes's avatar
Kenneth Reyes
Copper Contributor
Jan 05, 2018

Hi Brian,

 

can you try this one?

=REPLACE(REPLACE(A1,1,FIND("(",A1),""),FIND(")",REPLACE(A1,1,FIND("(",A1),"")),100,"")

 

Thanks,

kenkie

Resources