Extract Alphanumeric string from a cell

Good morning,

I have a list of Account names with Account numbers inside them, the account number is not in a set place but its always three letters then three numbers eg. AAA001

The data may look like:

Barclays Bank BLC041 London
BLC041 Barclays bank
Barclays Bank (BLC041)

Any help would be much appreciated!

EDIT: Forgot to say that I wanted these Account numbers in a seperat column by themselves

Hi

Try this Array Formula(Control+Shift+Enter0

=SUM((MID(0&A1;LARGE(IF(ISNUMBER(MID(0&A1;ROW($1:$256);1)*1);ROW($1:$256);1);ROW($1:$256));1)*1)*10^(ROW($1:$256)-1))