Extract text from middle of string using character count

[rythmic_flow]

Hello,

I would like to extract the name only from a cell that comes through in the following format:

abc123456789 JOE BLOGGS abc123456789

The name can very in length, but the number of characters from the far left and far right of the string always stay the same amount.

Is there a formula that can count characters both from the right and from the left and extract what is in the middle?

Or are any different ways to do this?

 

[rythmic_flow]

Alpha, it does work. I'm not sure what went wrong last time, but it is working.

Have marked this as fix! Thanks