Imagine you have a long list of product part numbers. Lets assume they are in this kind of format 100.09.20 which I would say is a common format to write part numbers. Some may even include text, but it makes no difference.
Now the question comes, 'How do I split this sequence of numbers?' Let's say I want to obtain the last 2 numbers in the sequence.
Select the data column that you need to separate then go to Data > Text to Columns
Ok, what if the numbers are not so neatly formatted. Something like this perhaps?
In this case, you will need to choose the Fixed Width option like below.
Clicking Next will bring you to the following window. Just click on where you want the split to be. To have multiple splits, just click in another character column.