Microsoft is a great program that allows users to store and analyze large and even small amounts of data for interpretation. Apart from using only numerical values in Excel, you can also have cells that contain text within your data. To understand your data better, you need to differentiate cells that contain numbers and those […]
How to count Excel cells with text (with examples) Read More »
So you have filtered your data, and now you need to count the excel cells. Counting Excel data that is not filtered is not hard but becomes a little bit tricky after filtering your data. In this article, I will take you through some of the methods you can use to count in Excel after
How to count in Excel after filter Read More »
Unlike text editing softwares such as Google Docs and Microsoft Word, Excel does not feature change case. For this reason, users rely on functions to change the case of their text string. Excel LOWER function is one of many text functions that you can use to change the case of a sentence string. What does
How to use Excel LOWER Function Read More »
When working on a large spreadsheet locating data becomes more difficult. Thus you need to use a function to speed things up. The search function is one of the functions used to locate and return values on Excel. In this article I will guide you on different ways that you can make use of the
How to use Excel Search Function Read More »
The name CONCATENATE means to combine or to join. The Excel CONCATENATE function combines or joins text located in different cells to one cell. Microsoft introduced the CONCAT function to replace CONCATENATE in 2016. However, CONCATENATE will remain active in later versions for compatibility issues. The best practice is to use the CONCAT function since
How to use CONCATENATE Function in Excel Read More »
