Regular expression to find cells that start with a word?

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
2 Likes

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.