I have been struggling to write a macro to automatically do the following in an Excel column range:
- limit the cell entry to text only (no periods, dashes, spaces, numbers, etc)
- restrict the text entry to either 2 or 3 letters
- convert the text entry to uppercase only.