Hi, I've got a table which has an order reference field. I need to extract a 5 character code from this field. Unfortunately, due to some being automatically generated by different systems and others being manually entered there is no consistency to the format, therefore I can't use mid, left functions to get the info. However, in every case the code that I need always begins with E and is then followed by 4 numbers - is there a formula that I could use that could find and extract this code? Any help greatly appreciated.