Uppercase Column

[default_name]

Hey guys,

Not sure if this is possible or not, but I figured that if anyone knew, it'd be someone on here.

Is there a way to make an entire column UPPERCASE without the use of VBA?
I am trying to avoid turning an xlsx into an xlsm.

Specifically, Column E is a yes/no column and should contain either 'Y' or 'N' in each cell of that column...however, if a user types in a 'y' or a 'n' i'm hoping to find a way to have those inputs automatically change to caps.

I see the simple UPPER(cell or range) command, but I am wondering if there is any other way.
Perhaps with conditional formatting?

Thanks in advance!

 

[Fluff]

You could use Data Validation, to prevent them from entering anything other than Y or N.

 

[default_name]

You could use Data Validation, to prevent them from entering anything other than Y or N.

Thanks Fluff! I thought about Data Validation as well.
It looks like VBA is really my only other option here haha

 

[Fluff]

If Dv won't work for you, then VBA is the only solution that I know of.