I have a column of data (G) which has people's names and roll numbers in it.

These are user input and although the correct format is 123456 John Smith
there are instances where the name is before the number or there is no number
or name e.g.

123456 John Smith
Bill Bobbins 987654
Fred Figgis
438764 Mike Morris
907856

I need to reformat the data so if there's a number it always appears before
the text so the above examples would show as:

123456 John Smith
987654 Bill Bobbins
Fred Figgis
438764 Mike Morris
907856

I haven't been able to do this formulaically yet so I'm really struggling to
find a manual solution.

Any help would be greatly appreciated.

Thanks a lot