About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store



Past Tip of the Day


Lee writes "How do I capitalize the values in a particular column? Do I use the function "UPPER" - if so, what is the complete formula? Thanks very much for your help."

There are two possibilities. =UPPER() will change the text to all upper case. =PROPER() will change the text to proper case.
If cell A2 has the word "john smith", use these formulas:
In B2: =UPPER(A2) to return JOHN SMITH
In C2: =PROPER(A2) to return John Smith

Copy the formula from B2 down to all of the rows where you have data in A.

You can then highlight these cells in column B, Edit - Copy, highlight A2, then Edit - PasteSpecial - Values - OK to overwrite the original values in A.

One note about =PROPER(). It works fairly well, but "mcdonald" changes to "Mcdonald" instead of the generally accepted "McDonald".

By Bill Jelen on 19-Nov-2001 Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.