L
LinLin
Hi Everyone
Is there anyway to format a cell so that if data is entered as a lower case
alpha character, it will automatically change it to Upper case?
IE: I enter a
And excel comes back with A
Also for a combination of letters:
help
comes back as: HELP
I am not so concerned with a mix of lower and upper case (of course, if the
solution can ensure a mix becomes all upper case, that would be cool too!)
thanks!
Is there anyway to format a cell so that if data is entered as a lower case
alpha character, it will automatically change it to Upper case?
IE: I enter a
And excel comes back with A
Also for a combination of letters:
help
comes back as: HELP
I am not so concerned with a mix of lower and upper case (of course, if the
solution can ensure a mix becomes all upper case, that would be cool too!)
thanks!