Oct 31 2021 10:30 AM
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.
Oct 31 2021 10:54 AM
I tried replace and flashfill and both works in my sheet.
=REPLACE(A2,FIND("(",A2),FIND(")",A2)-FIND("(",A2)+1,"")
Oct 31 2021 11:18 AM
@BlackrosePress Alternatively use Text-to-columns. " (" as delimiter (i.e. a space and a left bracket). Skip the second column.