Just to share, I have minor problem with a document that all letters are in upper case. I want it to be in proper case. So do I need to type it all again? No!. I’m using VB Function to change the case.
In Excel, go to Tools->Macros->Visual Basic Editor or press ALT+F11. Insert new module, Insert->Module. Then paste the code below.
Dim Rng As Range
On Error Resume Next
Application.EnableEvents = False
For Each Rng In Selection.SpecialCells(xlCellTypeConstants, _
If Err.Number = 0 Then
‘ Rng.Value = StrConv(Rng.Text, vbUpperCase)
‘ Rng.Value = StrConv(Rng.Text, vbLowerCase)
‘ Rng.Value = StrConv(Rng.Text, vbProperCase)
Application.EnableEvents = True
Uncomment on the Rng.Value for whatever purpose you will use it for. Close VB Editor, to use it, on the document, press ALT+F8, a popup menu will appear, just choose ChangeCase in the function, select Run. Tadaaaaa. Hope it works for you as it works for me.
Powered by ScribeFire.