No thanks...do not wish to use any formulae for this task, as I stated I
wish to be able to select single or multiple text entries, then have an
OPTION to change the case to whatever I need.
Terry
"R.VENKATARAMAN" wrote in message
...
=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
|