I am trying to get all occurrences of text from within one cell, for example

Dog0001 Cat001 Dog000007 Cat008 etc

Ideally it should return any word that return anything that begins with 'Dog' i.e. Dog0001 Dog000007

Thanks