PROBLEM: You need to change UPPERCASE string/text to Title Case
SOLUTION: Use PROPER function
RESULT:
FOLLOW ME TO STEP-BY-STEP GUIDE
This tutorial will explain how to change your UPPERCASE text to Title Case text!
1. Type your uppercase text. For example, I type “PLEASE, CHANGE THIS TO TITLE CASE” in cell B2
2. Move your cursor to other cell (for example, I move my cursor to cell B4. See below)
3. Type this in cell B4, “=PROPER(B2)” then press Enter. B2 are the cell containing text you want to change.
4. Then you will see the result! See below:
Done !!!
Sometimes, you’re not need UPPERCASE and formula anymore after you get the Title Case text version. So you can copy ONLY the VALUE (“Please, Change This to Title Case” not “=PROPER(B2)” or uppercase version).
For this, do following steps:
1. Right-click on cell B4, then click COPY.
2. Move your cursor to other cell (for this example, I move to cell B6)
3. Right-click on this cell, then click PASTE SPECIAL…
4. Choose options to VALUES in paste options, then click OK button
Done !!! Now, you can delete other cells.
Hope helpfully 🙂
December 2, 2008 at 9:14 am |
Terrific. It helps a lot. Thanks for posting this blog 🙂
Thanks again,
Suresh
December 3, 2008 at 8:32 am |
Your welcome. I’m glad if it’s helped you.
December 14, 2008 at 11:34 am |
Thank you very very much. Most people online post contents to gain something. I found somebody even asking for money to share this very info you posted for free.
May you be rewarded!!
The Net is still a nice place thanks to people like you.
Good luck.
December 19, 2008 at 9:56 am |
Thanks for your comment, Sha.
September 24, 2009 at 10:12 am |
do u online jobs
relating excel sheets
October 5, 2009 at 2:16 pm |
yes…. 🙂
February 9, 2010 at 9:23 am |
Wonderful tip – very useful, saved a lot of time. Many thanks
February 22, 2010 at 1:05 am |
Awesome – thank you for sharing! Saved me so much time! 🙂
February 23, 2010 at 6:51 am |
COOOOOOOOOOOL
March 1, 2010 at 3:26 am |
Enjoy it 🙂