Delete text within a specific cell column

Occasional Visitor

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


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


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