"Terry" wrote in message
...
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

You have two options.
1. Write some VBA and assign a button to it, or,
2. Re-design Excel.