Assuming your original IDs are in column 1. Use a helper column eg
=UPPER(A1), then copy down. You can then copy and Paste SpecialValues to
overwrite the original data.

--
Ian
--
"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?