I am trying to write a formula that pulls all data in column A but removes those that contain brackets to hopefully output to look like picture 2. Any help would be much appreciated :)

enter image description here enter image description here

  • Please do not show screenshots but a table of sample data together with a table that shows your manually entered desired results. Dec 5, 2022 at 21:15

1 Answer 1


You can get a subset of rows in a column or multi-column range with the filter() function. To use a condition like "the value in the row contains a specific character", you can apply the search() function, like this:

=filter(A1:A, iserror(search("[", A1:A)))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.