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 :)
1
-
Please do not show screenshots but a table of sample data together with a table that shows your manually entered desired results.– doubleunaryDec 5, 2022 at 21:15
Add a comment
|
1 Answer
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)))
answered Dec 5, 2022 at 21:15
