Use =PROPER(A1)

Also just for information sake
=UPPER(A1) to convert to Upper Case
= LOWER(A1) to convert to Lower Case

--
If this post helps click Yes
---------------
Jacob Skaria


"O2bardy" wrote:

example instead of JOHNNY WALKER
I want it to be Johnny Walker.