Consider a field in Excel that contains a number followed by a ‘\’ character, followed by 3 letters.
For example: 123456789\ABC
No let us say that you would like to get the part of the string that exists before or after the ‘\’ character into another field.
You could write a VBA script that uses regular expressions, but this can more easily be achieved using a combination of the RIGHT, LEFT, LEN and FIND methods. Continue reading