Is there a way to set a Data Validation to CAPS and LIMIT meaning I'm using Excel, Data Validation, Custom, =AND(EXACT(A3,UPPER(A3)),ISTEXT(A3)) this makes everything CAP. But I also want to limit how many charters allowed in this area meaning 10 or less... so far I figured out how to do one or the other but not both.
Or is this more a VBA code. I know good code to change the entire spreadsheet to caps but then it over rides the formulas which look at another tab within the spreadsheet to auto fill and are already captilized.
Bascially its a workbook with a tab "Upload" that some columns are needing user input while others auto populate based on information they input. In the end formulas need to stay, need o
Or is this more a VBA code. I know good code to change the entire spreadsheet to caps but then it over rides the formulas which look at another tab within the spreadsheet to auto fill and are already captilized.
Bascially its a workbook with a tab "Upload" that some columns are needing user input while others auto populate based on information they input. In the end formulas need to stay, need o
