In QE020 you looked at how to set up an Excel Spreadsheet to fix a manual data entry column, effectively standardising the various data values. This technique is extremely portable and we’ll talk about some of the additional options available to you.
It is important that you consider use-cases beyond what is presented when demos are provided, because often the demo will be on something that is not quite what you do, however, the reality is there is a direct synergy with what is being demonstrated and what you are looking for.