=upper("venkat") returns VENKAT
=upper(a1) returns the text in A1 in upper case

similary lower
proper will turn the first letter into uppercase

is this what you want;.


Terry wrote in message
...
Win XP Pro
Office 2003

Using "Excel" and wish to select any text in a worksheet to ALTER the case
to either upper or lower.
When using "Word" it is easy via the menu.
Is there a menu driven option in Excel please, as I do not like the idea
of
using a function for this purpose.

TIA