Unable to split text and numbers into Separate Cells that have no space

Good Morning!

I have been searching for a method to split cells that have text and numbers combined with no spaces between them. I have a sheet that has a column of codes, with varying lengths of text, that I need to split into a column of text and column of Numbers.

I have attached a very basic spreadsheet to explain what I am trying to do.

After I select get the text and numbers separated, I need to pull the last 3 digits (from the Left) and the 4th-7th digits (from the left) into their own columns.

The cells look something like this: They are originally located in column C2:C800.

EANENE10316080
EANENE10316080
EANENE10316080
EANENE10316080
EANENE10316080
EANENE10322083
EANENE10322083
DPDPDP00265081

I would like it to look like this (example cell: EANENE10316080)

D1 E1 F1

EANENE 080 10316


I have used the following code to pull the number out: but, I can't figure out how to pull the text out:

=MID(C2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},C2&"0123456789")),LEN(C2))

Any help would be greatly appreciated! Thank you in advance.