Excel Formula to extract a 5 character word from text string

[Ancarmusick]

Hello,
I need help with a excel formula to extract a 5 digit code (can be numeric/alpha) from the following text string. I can't seem to figure it out.
I need the following 5 digit code from the rows below.

Row 1 - I need X7777 (may have 0, 2, 4 letters after which I don't need)
Row 2 - I need 36600
Row 3 - I need 80008
[TABLE="width: 794"]
<tbody style="box-sizing: border-box; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased;">[TR]
[TD]0222 TA SOLUTIONS X7777 073015 1 132 00[/TD]
[/TR]
[TR]
[TD]0225 LADDER OR LG 36600 IL91 073015 1 50 00[/TD]
[/TR]
[TR]
[TD]0230 MOP/BROOM 80008 OT 073015 1 550 00[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for your help!

 

[Michael M]

As there doesn't seem to be any consistent logic...I'd suggest using Text to Columns !!!