Every system exports text with something wrong in it: spaces where they should not be, capitals typed at random, numbers stored as text and codes with the number you need buried inside. Fix each with a formula in a new column, so the fix still works on next month's export.