How do you use wildcards in Excel?

Okay, technically I’m not using excel. I have tried to write this formula in both Open Office and Google spreadsheets and have the same problem with both.

I would like to find every cell that contains the term “xyz” but every cell has [some random stuff then xyz.] I was hoping to solve this problem by searching for *xyz, but excel seems to be taking this literally and ONLY returns results for ”*xyz” rather than [anything xyz].

Is there a trick to telling excel that I mean to use * as a wildcard rather than as an actual character?