Forum Discussion
Delete text within a specific cell column
I want to delete certain text in a single column. The text looks like this: Abcd Efgh (Ijkl Mnop #1) Everything within the parentheses, including the parentheses themselves, are to be deleted...
I tried replace and flashfill and both works in my sheet.
=REPLACE(A2,FIND("(",A2),FIND(")",A2)-FIND("(",A2)+1,"")