How to automatically change a single letter text entry to caps??

[Guest]

Hi to everyone

Hopefully someone can help! I have a spreadsheet where users input a letter
from a to z into a textbox. How can I make Excel convert this letter to a
capital letter automatically, in case someone enters it as a lowercase
letter? Dont know if this can be done, but hoping it can!! I know about the
UPPER function, but that is not quite what I need as that function enters the
letter as uppercase into another textbox. I need it as uppercase in the
textbox in which it is entered.

Many thanks
Bigweed

 

[Bill Ridgeway]

I asked a similar question some while ago and received the answer that it
can't be done. I think you'll need a cell "as input" and a cell "input"
which tests for the input and returns information in the required format.

Regards.

Bill Ridgeway
Computer Solutions

 

[Andy Wiggins]

You would need to use VBA to capture the event and make any change
necessary.

Why do you want upper case input?

 

[Guest]

Just so it could look more presentable. Oh well, guess it will have to do!!
Thanks
Bigweed

 

[gls858]

Just so it could look more presentable. Oh well, guess it will have to do!!
Thanks
Bigweed

:

I use a small program called ASAP Utilities. It can be found at:

http://www.asap-utilities.com/

It has many useful tools one being convert text to upper case under the
options. It's free and has no ads. I find it quite useful.

One thing to remember is that the changes made can't be undone with
the undo button so make sure you have a backup copy before using the
tool.

Standard disclaimer: I'm in no way associated with ASAP utilities nor
do I receive any monetary compensation for promoting their product.

gls858

 

[swatsp0p]

Depending on how many options the users have for inputting a single
letter (how long of a pick list is too long for your users?), you could
use Data Validation and assign a List of Letters (all CAPS, of course)
from which the user can choose their desired letter.

Just another (non-addin, non-macro) option...

Cheers,

Bruce