First Letter Each Word UpperCase- Both for Cells & TextB

[I_AM]

Hi,
How to format so that the first letter of each word entered into a cell (and Also for a TextBox) is UpperCase and the rest of the word is LowerCase?

Thanks Regards Ron

 

[Yogi Anand]

Re: First Letter Each Word UpperCase- Both for Cells & T

Hi Ron:

Glad you found a solution -- and if we win the whole team wins -- so we all -- You, SIXTHSENSE, and I -- we all get the prize.

 

[SIXTH SENSE]

hi!
this is all i like this board!
Your knowledge grows as your heart filled with joy, the ultimate prize of success!

 

[I_AM]

Re: First Letter Each Word UpperCase- Both for Cells & T

Hi,
True enough, and no disrespect intended. I simply couldnt function with Excel if it wernt for all of you. Many thanks
Regards Ron