Tips and tricks – numbers

Here are some tips and tricks Hans uses in his work.

Remove characters from a string

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:

B1=LEFT(A1;LEN(A1)-3)

Compare values in columns

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:

C1=VLOOKUP(A:A;B:B;1;FALSE)