I want to make last name UPPER CASE..

[yosegmail]

yoseph worku zenebe .. I have this name in cell A1
I have tried to make the first two words of first letter uppercase
Yoseph Worku
but I find it difficult for the last word??
I tried FIND() function... for the 1st space" "
but to find the next " " don't know how???

 

[yosegmail]

UPPER(REPLACE(RIGHT(RIGHT(B3,LEN(B3)-FIND(" ",B3,1)),LEN(RIGHT(B3,LEN(B3)-FIND(" ",B3,1)))-FIND(" ",RIGHT(B3,LEN(B3)-FIND(" ",B3,1)))),2,LEN(RIGHT(RIGHT(B3,LEN(B3)-FIND(" ",B3,1)),LEN(RIGHT(B3,LEN(B3)-FIND(" ",B3,1)))-FIND(" ",RIGHT(B3,LEN(B3)-FIND(" ",B3,1))))),""))

I think this long formula would work....
assuming I have entered text in cell-B3

any short formulas???

 

[Stiuart_W]

Use the PROPER function.

Ie

=PROPER(A1)

 

[yosegmail]

thanks