In the example shown the formula in C5 is. Step 1 Select the data in your excel sheet on which you want to count the words in a particular cell. Copy the following lines of code.
Just reference the EnglishNumber function in your Excel spreadsheet as follows.
Just reference the EnglishNumber function in your Excel spreadsheet as follows. Step 3 Click Enter and you will get the exact number of words in a particular cell. In the Category list click a category such as Custom and then click a built-in format that resembles the one that you want. Essentially the function will convert a numeric value into a text string.