# Delete text within a specific cell column

Occasional Visitor

# 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

# Re: Delete text within a specific cell column

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

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

# Re: Delete text within a specific cell column

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