Validate data but then change the entry to upper case
DV
Allow: List
Source: W,L
Make sure In-cell dropdown is checked
"Ephraim" wrote:
Hi,
Is it possible to validate data to allow only W, w, L, l and then
convert the lower case entry to upper case?
I don't want the user to have to keep pressing shift or caps lock
while entering data in these cells.
Ephraim
.
|