• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2196
  • Last Modified:

Capitalize first letter of text in MS Excel

I have a column of text in MS Excel that is in all caps.  Is there an easy way to change it, so that only the first letter of each cell is capitalized.
0
heatherm6
Asked:
heatherm6
1 Solution
 
VBRocksCommented:
You can use a formula in another column.  For instance, if column A has all caps, then in column B you
can use =PROPER(A1), which will produce "This Is A Test";
or you can use =LOWER(A1), which will produce "this is a test"

0
 
Wayne Taylor (webtubbs)Commented:
Hi heatherm6,

Here is a macro you can use which will convert all the cells in column A to Proper case....

    Sub ConvertToProper()
        Dim cell As Range
        Application.ScreenUpdating = False
        For Each cell In Intersect(Columns("A:A"), ActiveSheet.UsedRange)
            If cell <> "" Then
                cell = Application.Proper(cell)
            End If
        Next
        Application.ScreenUpdating = True
    End Sub

Regards,

Wayne
0
 
Michael_DCommented:
You can use this formula to convert ONLY first letter of the cell to Upper case and ALL others to lower

=CONCATENATE(UPPER(LEFT(A1,1)),LOWER(RIGHT(A1,LEN(A1)-1)))
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now