Sunday, May 24, 2009

UPPERCASE to Title Case

How to change your UPPERCASE words with Title Case ?

HINT: Use PROPER() function on Excel
Example : MICHAEL JACKSON become Michael Jackson

Step 01:
I wrote "MICHAEL JACKSON" on cell B2







Step 02:
I move my cursor to cell D2 then write "=Proper(B2)" then press Enter








The Result:

4 comments: