Counts the number of non-empty cells in a selected range.
Logical comparison within an IF function any one of the arguments to be true.
logical comparison within an IF functions for more than one arguments to be true.
Removes extra spaces in a cell whether at beginning, trailing or between the words.
Allows us to enter data patterns to other cells.