Category: Excel Function

The CLEAN function will remove all the nonprintable characters from the text. Formula: = CLEAN (text) Explanations: – Text is required; the text that you need to remove nonprintable …

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. The IFS function works in Excel 2019. …

The CONCAT function is one of the text functions that allow you join two or more cells together. This is the function to replace the CONCATENATE function, but easier …

The COUNTBLANK function counts the number of empty cells. Formula: = COUNTBLANK(range) Explanations: The range is required, which is the range to count the empty cells. Cautions: Cells with …

The COUNT function counts the number of cells that contain numbers. Formula: = COUNT(value1, , …) Explanations: – Value 1 is required, which is the first cell to count;– …

The TRANSPOSE function reverses the direction of the vertical and horizontal range of cells. Formula: = TRANSPOSE(array) Explanation: Array is required, the data range to be transposed. Step 1: …