There is a formula to transfer lowercase items in uppercase. Use
=UPPERCASE("Celladres which contains lowercase")

--
www.wolters.100.nl

"Ron Lehr" <Ron schreef in bericht
...
I use MS Excel 2003. Microsoft should update the Excel program to include
the same ability Format-UPPERCASE that is built into MS Word 2003. A
user
should simply have the ability to highlight the selected cells and then
Format-UPPERCASE and then all text within the cells should uppercase.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc