Here are some tips and tricks Hans uses in his work.
In a set of strings, a specific number of characters should be removed from the end of the strings.
To remove 3 characters from the end of a string (A1) use the following Excel formula:
The values in 2 columns should be compared to check what strings are present in both columns.
To compare the values in columns A and B, use the following Excel formula: