I have data in a column that looks as such:
SMITH_JOHN.TGA
JONES_SAM.TGA
MARTIN_DONALD.TGA
I'm simply trying to find a formula that will remove the .TGA from the name and swap the first name and last name so the results would look like:
JOHN SMITH
SAM JONES
DONALD MARTIN
I can accomplish this using multiple formulas across multiple cells, but I'm looking for a single formula or VBA script to do the work without all the clutter.
Bookmarks