Hey @clark.nc
There are many regex formulas to do this. You can try this one: [SOLVED] How do you extract "first name" from "full name" field? - #17 by kenlaji
Then you can do a find and replace with the first name and replace it with nothing. Then add it to the end of the string.
Does that make sense?