I have an excel file to load into my database, I'd like to rearrange the name field to this
FIRSTNAME M LASTNAME
instead of the format it's in now which is
LASTNAME, FIRSTNAME M.
to keep it consistent with a previous load I have loaded into my database. Is it possible to do this somehow and put it into the same column? I've searched, and have only found that people have been wanting to split them into multiple columns.
Thanks in advance.