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:

Please Login or Register  to view this content.

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

Thank you for the quick reply. The text length can vary from 5-8 characters. I apologize that I did not put that in my original post. That makes it more challenging to use the text to columns.

Any other direction to pursue would be greatly appreciated.

Thank you again!

Ron,

Thank you very much! I really appreciate the help! That is exactly what I needed!

Thank you again for the quick reply!

Have a great day!

Ron,

If you don't mind... and you have a moment, I have not figured out all of the 'functions' and how to use them most appropriately. What was the purpose of using TRIM in your following code and your subsequent codes?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks again. Really appreciate your help.