Split alphanumeric strings into three different columns.

Hello to all -

I am working on a report but I need help with the split of text cells that contain text and numbers. I had worked in some formulas and also received help in the forum, but I got stuck again when I drag down the formulas. In the attached file, you will see two tables. The one in the left is my current job. In the table of the right is how the table must look like. The table is complete and will give you the whole idea.

Basically, I need to split the cell into three categories that are "Family", "Model" and "Phase". In example:

Cell Family Model Phase
CCA CCA
DC50X DC 50 X
DCX3300CRD DCX 3300 CRD
DPC2434 DPC 2434
DCT-1700 DCT 1700
DCT-1800 DCT 1800
DCT-1800P3 DCT 1800 P3
DCT-1800P4 DCT 1800 P4

I will be gald to receive your help. And due to Security Settings, please no VBA codes.

Best regards and please have a great day.

SamCV.
Matamoros, Mexico.

Hello hemesh -

I tested the formulas and worked very well. You are awesome!!! I have some years using excel but I recently begin to study it more deeply. And I have more to learn regarging formulas, functions and excel tricks.

Thank you very much for the help you gave me. It will save me a lot of time.
Maybe you are one of Chandoo's follower. Very clever work.

Best regards and please have a great day and excelent weekend.
(Saludos cordiales y que tengas un gran día y excelente fin de semana).

SamCV.
Matamoros, México.