Custom data validation

So far, you could find a lot of texts on the web site “Excel Kitchenette” about data validation. Most of them were about lists, since this functionality is often used, and further the choice of data type, setting the text length, number range or date were mentioned … When activating the Data Validation option, there are also custom rules, where it is possible to enter a formula based on which the validation is being performed.

Pieces of text

By implementing business software we usually retrieve Master data from the previously used application, primarily the Partners and Items. Data is usually exported from old software to Excel, it is processed, and imported into a new application. When processing, there is often a need to “cut” the text in one of the columns from the left, from the right or from the given position, or to find a part of it in order to use it to generate some new content …