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