0

Quick Tip – Finding (*) Stars in Excel

Posted by admin on Jan 8, 2010 in Uncategorized

Excel ImageThis 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.

Tags:

Copyright © 2010 The Test Managers Blog All rights reserved. Theme by Laptop Geek.