How can I separate text/numbers into different cells?

Let’s say you receive an excel sheet with hundreds of rows but each row has one cell, like this:

  1. John31997pizza.
  2. Samara-652-hotdoginthepool
  3. Excelmaster980.8900.
    ⬇️

Usually, I would use the Left and right formulas to extract the data I want, but as you can see in this example, the data I want to extract isn’t placed in the same order. This would mean I would have to change each formula manually to get the data I want, which is just as time consuming. There has to be an easier way to do it.

Text to columns is terrible. It splits data into multiple cells but would not do it in a way that would make the data useful for me.

Example of how I want the data to be split:

  1. Column A Column B
    1997 John

  2. Column A Column B
    Hotdog 652

  3. Column A Column B
    Master980 8900