Extract one text from csv file

[jsalotra]

Hello,

I need a help to create a formula to extract one text starting with same first four characters. Please see attached file.
For example column A is copy of CSV file and need to extract reference number starting with "ABCD"with two alphabets and digits assigned with it. The reference number does not align when use "text to columns"

Thanks!