I have cells that start with a certain word. I also have cells with text containing the same word.
Is there a way to find the cells that start with that word, without finding the others?
Thanks
I have cells that start with a certain word. I also have cells with text containing the same word.
Is there a way to find the cells that start with that word, without finding the others?
Thanks
Hallo
try regex:
^yourword
Hi
It seems the same. It still picks up all instances of the word.
For example, if you had a cell that said “Monkeys can climb” and another that said “They said we were monkeys”, and you only wanted to find the one that started with “Monkeys”, but not the other.
Oops, I was wrong - it did work!
Thanks again!
Find: ^Monkey
with [x] Regular expressions.