Excel will split the text string on the basis of space ( ) delimiter. The output array will hold the following 3 values: ‘The’, ‘Windows’, and ‘Club’.

To use COUNTIF: Select the cell in which you'd like to display your COUNTIF output. Type in the =COUNTIF function. Within a ...