mardi 2 juillet 2019

Find words in a cell and return a true or false using regexract

I'm trying to find words in a cell using regextract but it is not bringing back all words in the cell.

It will bring back:

gamer

but not

_gamer

or

@gamer

But I need all of them. Here is the sheet I am using.

I'm trying to find words in a cell using regextract but it is not bringing back all words in the cell:

=REGEXEXTRACT(C3,"gamer|gaming|game")

true

Aucun commentaire:

Enregistrer un commentaire