Remove spaces in Excel with the TRIM function
If you want to remove the extra spaces in a cell, there is a function for that ; it's the TRIM function. But you must convert your formula in values.
TRIM
Count Words in an Excel cell
How to count the number of words in an Excel cell? With Excel, you can use 2 techniques to return this result.