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 assume to have that text delete, I'd enter (* . I've tried Filter, but ended up deleting data on the entire page.
Thanks for your help.
2 Replies
BlackrosePress Alternatively use Text-to-columns. " (" as delimiter (i.e. a space and a left bracket). Skip the second column.
I tried replace and flashfill and both works in my sheet.
=REPLACE(A2,FIND("(",A2),FIND(")",A2)-FIND("(",A2)+1,"")
