Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

change case in excel

Posted by Deepika on May 21, 2000 10:39 PM

If i have a excel sheet which is all in CAPS how do i make it Sentence case

Re: change case in excel

Posted by Ivan Moala on May 22, 2000 3:56 AM

Hi Deepika
One way to do this Via a macro

Sub MakeProper()
Dim TextRgCaseChg As Range
Dim cell

Set TextRgCaseChg = Selection.SpecialCells(xlCellTypeConstants, 2)

For Each cell In TextRgCaseChg.Cells
cell.Value = Application.WorksheetFunction.Proper(cell.Text)
Next
End Sub

Ivan

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.