Capitals

[Nigel Martin]

I have written a spreadsheet where the letters A, C, E, F, S and U are entered into cells. Using Validation I have made it so that only these letters can be entered (so far so good). Is there a way to make Excel auto correct if the end user enters any of the above letters in lower case to upper case. I have tried adding entries into Auto Correct but this seems to have a global effect. I need it to be worksheet specific or at the very least work on only that 1 particular workbook.

 

[Aladin Akyurek]

On 2002-03-01 11:52, Nigel Martin wrote:
I have written a spreadsheet where the letters A, C, E, F, S and U are entered into cells. Using Validation I have made it so that only these letters can be entered (so far so good). Is there a way to make Excel auto correct if the end user enters any of the above letters in lower case to upper case. I have tried adding entries into Auto Correct but this seems to have a global effect. I need it to be worksheet specific or at the very least work on only that 1 particular workbook.

You could upper the validated input:

=UPPER(A1)

where A1 houses the validated entry.

 

[Mark W.]

Why not have your data validation enforce upper case...

=EXACT(UPPER(A1),A1)

 

[Nigel Martin]

Many thanks it works well.