Use CTRL + E to separate cell content to different columns

The smart filling tool CTRL + E can work in different ways, it will depend on what you want to accomplish and what you teach excel to do

in this example we will use it to separate the cell content to different columns following a pattern.