On Mar 20, 11:06*am, Teethless mama
wrote:
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
.- Hide quoted text -

- Show quoted text -

Unfortunately the cells are so close together that using a list with
in-cell dropdown covers the cell next to it which slows data entry.
I was hoping to find a solution that would allow the user to input
either W,w,L or l and then convert the lower case to upper case
automatically.
W or w represents a Win and L or l represents a Loss. Because the
lower case l may be confused with the number 1 I wish to keep
everything in upper case. A win is worth one point and a loss get's
zero points.