CPAS letters to small Letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
This is Harishanker.
I have one Doubt in Excel..Pls clarify me as early as possible...How to
change the CAPS letters to small letters ?Is there any Keyboard short cut key
is there?I f there in no Short key ,then how to change ?Give me a detailed
Procedure for that.If there is any chance,Pls give me Examples how to
change?Thank you all ....

Thanks & Regards,

Harishanker.Ch
 
Sub ChangeCAPS()
Dim cell as Range
For each cell In Selection
If Not cell.HasFormula Then
cell.Value = LCase(cell.Value)
End If
Next cell
End Sub

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Hi Harishanker

Excel doesn't do that. You need a small macro. Select the cells to be
converted and run this:

Sub Lower()
Dim Cel As Range
On Error Resume Next
For Each Cel In Intersect(Selection, ActiveSheet.UsedRange)
Cel.Formula = LCase$(Cel.Formula)
Next
End Sub

HTH. Best wishes Harald
 
In addition to the macros provided by Bob and Harald, there is a worksheet
function.

=LOWER(cellref)


Gord Dibben MS Excel MVP
 
Back
Top