Split contents of cell

I have a single cell (say A1) with a name and surname in it, eg Lynne Pike

I would like to split the name into two seperate cells, but with the surname in the first cell (say A3) and the first name in the next cell (A4)

I am able to split them by using the text to columns but it keeps it in the original order

Is it possible to oder them as above please

Thank you so much
Lynne