Dinesh, there is an upper function, you could put this in a nother column
and copy down, =UPPER(A1) , then paste special back over the data or you
could use a macro like this and do it all at once

Sub Change_To_Uppercase()
'select range and run this to change to all CAPS
Dim cel As Range
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = UCase$(cel.Formula)
Next
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dinesh" wrote in message
...
Is there a way that we can convert lower case charecters to upper case in
MS
Excel cells? I have more than 150 User ID's written down in Excel using
both
Upper case and Lower case. But now I need to convert them in to upper
case.
Is there an option for that?