Numbers before 1st asterisk, 2nd asterisk, 3rd asterisk

Hello. How do I get a formula to return all numbers before 1st asterisk, all numbers between 1st and 2nd asterisk, and 2nd and 3rd asterisk?

Assuming the cell that has the numbers is A2 you can put this formula in whatever cell and drag down.

Formula:

=SUBSTITUTE(MID(SUBSTITUTE($A$2,"*",REPT("*",LEN($A$2))),(ROWS($A$3:A3)-1)*LEN($A$2)+1,LEN($A$2)),"*","")

If you want to drag right instead of down you can replace the ROWS($A$3:A3) with COLUMNS($A$3:A3).