You can use a helper column of cells.

Say your data is in A1:A150,
put this in B1
=upper(a1)
and drag down.

You could select column B
Edit|copy
edit|Paste special|values
and delete column A if you wanted.

Dinesh wrote:

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?

--

Dave Peterson