How to remove a "space" from a name filed and move the next text characters over to another column.

We have about 12K records where name is " JOHN" or "JOHN  J" or "JOHN ", I have heard there is a simple way to find and replace the space character, however I need to move any character after the space to another Colum.

Example:
FNAME
----------
JOHN J

Needs to be
FNAME  MNAME
---------   ----------  

JOHN      J