How do I format minuscule word in capital letter one in excell?

K

Kevin B

=Proper(Text)

So if the value is in cell A1 in cell B1 enterthe formula =Proper(A1) and it
will uppercase the first letter of each word.
 
Top