I have a issue where I have a list of 3 letter codes seperated by a ; that I
need to grouped by the first letter of the code (ABC, ACB, AAA and BAA, BAB,
BAC and so on) but I'm unable to figure out how to do this in either Excel or
Access. There are about 60,000 rows and 1 code to 500 codes in each cell.

Please help