I am trying to come up with a formula that will allow me to count the number of words in a cell or range of cells e.g.
A1 has text "AB CD"
A2 has text "AB CD EF"
The result I desire is 5. I have tried using countif but havent been able to make it work for me. Do I need a custom function for this? If so any suggestions would be be appreciated.
A1 has text "AB CD"
A2 has text "AB CD EF"
The result I desire is 5. I have tried using countif but havent been able to make it work for me. Do I need a custom function for this? If so any suggestions would be be appreciated.