Find when a character "ISN'T" in the cell

THEBookMan · November 9, 2024, 4:48pm

I wold like to use FIND to locate cells that do NOT have a specific character in them.

Any Idesa ?

Thank you,
⌡im [THE BookMan]

karolus · November 9, 2024, 5:17pm

Hallo

=FILTER(A$1:A$100;ISNA(REGEX(A1:A100;"your specific character here")))
or
=FILTER(A1:A100;ISERROR(FIND("your specific character";A1:A100)))

THEBookMan · November 9, 2024, 5:44pm

Thank you,
⌡im [THE BookMan]

THEBookMan · November 9, 2024, 8:29pm

How can this formula be used in a column
I tried severl variations of: =if($B1 = ISNA ("@"), “@”, “-”) so it can be copied down the whole of column C

joshua4 · November 9, 2024, 8:45pm

Can you clarify? Do you mean that you want a TRUE (no such character) or FALSE (has character) in a given column for each row of the data instead of a collection of values that do not have the character? If so, that would just be the gooey center of the FILTER that @karolus gave:

=ISERROR(FIND(“your specific character”;A1))

karolus · November 10, 2024, 9:30am

thats random garbage! … wild guess…you maybe after:

=IFNA(REGEX(B1;"@");"-")