Delete text within a specific cell column

Copper Contributor

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 

I tried replace and flashfill and both works in my sheet.

=REPLACE(A2,FIND("(",A2),FIND(")",A2)-FIND("(",A2)+1,"")

@BlackrosePress Alternatively use Text-to-columns. " (" as delimiter (i.e. a space and a left bracket). Skip the second column.