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