How many names

[lapta301]

Could I trouble you for a formula to count the number of words in a cell. These are actually names so in an example of Stephen Thomas Smith the answer is 3.
Such a simple question but I have thousands of rows that I need to review.
As ever my sincere thanks

 

[tyija1995]

Hey, given the text is in cell A1 use this formula:

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1

EDIT: Nested a TRIM incase of any unnecessary white space.

 

[lapta301]

Thank you it works a treat.
My sincere thanks