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

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