COUNTA function counts the number of non-empty cells in a selected range. It will count cells that have numbers and/or any other characters in them. This function counts cells containing any type of data in a cell, including error values and empty text (“”). For example, if the range contains a formula that returns an […]

# Function

## How to Use Not Function in Excel – Infographics

The NOT function has only one argument. It can be used on its own also, but it is usually used along with IF function. Normally the logical functions return TRUE if the matched argument is true and FALSE if the matched argument is false. But NOT function gives FALSE if the matched argument is true, […]

## How to Use TRIM Function in Excel – Infographics

TRIM function is useful for removing extra spaces in a cell whether at beginning, trailing or anywhere between the words. Often when you pull data from a database you may find some extra spaces are put in behind or in front of legitimate data. This can create huge discrepancies. Especially when you are trying to […]

## How to Split Text Data of a Cell to Column in Excel

In our previous post “10 Basic Excel Functions That Everyone Should Know” we learned how to use the =CONCATENATE() function. Concatenate merges data of different cells into one cell. What if I want to split the data of a cell into multiple cells or in other words how to reverse the concatenate function? For example, I […]