View Single Post
  #3   Report Post  
Terry
 
Posts: n/a
Default

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