Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
COUNT
Welcome to this tutorial on how to find invalid characters in Microsoft Excel. In this tutorial, we will explore different methods including formulas and conditional formatting to detect and highlight characters you define as “invalid” in your Excel worksheets. Since you can easily customize the list of “invalid” characters, this approach is extremely flexible and…
Read More
Have you ever wanted to see how many times a certain text string pops up in a set of data? While you can use Ctrl + F to find values, you may need a search feature that’s more discerning and responsive. Luckily, there are several (much faster!) ways you can count cells that contain specific…
Read More