However for the general text you may use this for counting the number of words in Excel. To count the total words in a cell you can use a formula based on the LEN and SUBSTITUTE functions with help from the TRIM function. Calculate the length of service in years.
When you refer to a cell using this formula it will return 7 in the result.
If you want to save hours of research and frustration try our live Excelchat service. With our formulas you can quickly calculate 90 days from date 45 days before date and count whatever number of days you need. 30-day free trail. When you refer to a cell using this formula it will return 7 in the result.