Check If A Cell Contains Specific Text

less than 1 minute read When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functions. The SEARCH function will give us the starting position of the text you’re trying to find, when that is wrapped in the ISNUMBER function we will end up … Read more

Word Count From Cells

less than 1 minute read There’s no built in way to count the number of words in Excel, but using the following formulas will get it done. Download the example workbook here: Word Count.xlsx Count the number of words in a cell ‘ A2 as the following sentence (without quotation marks) to get the word … Read more