This is a really quick post.
Today I was looking to see if I could find a star “*” in excel and everytime I pressed search excel treated it as a wildcard and highlighted every cell in turn one by one.
To find the star I had to use the excel escape character of tilda “~”
so in the end in the search box I typed ~* and it found the star just fine.
Like I said just a quick tip in case its useful to anyone else.