I am trying to write a formula that pulls all data from column A that doesn't contain brackets.

Source Data
enter image description here

Desired Result
(no values containing brackets)
enter image description here

  • 1
    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 text string in the row does not contain a specific character", you can apply the search() and iserror() functions, like this:

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

See search() and iserror().

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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