1. How to Count: In this chapter, we will discuss how to count the number of cells with different conditions, such as blank cells, cells with numbers, cells with text, cells starting or ending with a text string, more…

2. How to Check: In this chapter, we will discuss how to check whether a value meets certain conditions, such as text value, reference value, logical value, even number, odd number or error, more…

3. How to Locate: In this chapter, we will discuss how to locate a space, number or line break in a text string, more…

4. How to Extract: In this chapter, we will discuss how to extract one or multiple letters, words from left or right of a text string. We will also discuss how to extract text based on the location of special characters, more…