Saturday, December 15, 2012

How to Convert the First Letter to an Uppercase in Excel


1. Decide if you want the first letter of every word to be capitalized ('Pete Is Great'), or just the first letter in the cell ('Pete is great'). In this example, assume that the original text ('pete is great' - note no capitals) is in cell A1, and you want the text capitalized in cell B1.
2. Enter the following Excel code into cell B1 if you want every word to be capitalized:=PROPER(A1)This will give the output 'Pete Is Great'.
3. Type the following Excel code into cell B1 if you only want the first letter of the cell capitalized:=UPPER(LEFT(A1,1))LOWER(RIGHT(A1,LEN(A1)-1))This will give the output 'Pete is great'.The 'UPPER(LEFT(A1,1))' part of the function tells Excel to return the left-most character in cell A1 in upper case. The 'LOWER(RIGHT(A1,LEN(A1)-1))' tells Excel to return all but the left-most character as lower case.

Blogger news