When using a drop down box that references a table, is there a way to configure a cell entry that uses data validation that references a table to automatically adjust case to match the in the table's data? (for instance, if a table's data contents start with a capital (such as, Abby) then if I manually enter lower case characters (such as, abby) then my entry is automatically adjusted to match the case of the table's data).
Bookmarks