CPAS letters to small Letters
 

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

CPAS letters to small Letters
 

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)

"Harishanker.Ch" wrote in message
...
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

CPAS letters to small Letters
 

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

"Harishanker.Ch" skrev i melding
...
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

CPAS letters to small Letters
 

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

=LOWER(cellref)


Gord Dibben MS Excel MVP

On Wed, 2 Aug 2006 00:07:02 -0700, Harishanker.Ch
wrote:

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