I have a series of names on my spreadsheet I'm running. Currently I have a cell that says "Carter, Jeff - LA." I want it to read "Jeff Carter."
Other examples:
Steen, Alexander - STL = Alexander Steen
Sharp, Patrick - CHI = Patrick Sharp
Duchene, Matt - COL = Matt Duchene
I have a formula I can use to reorder the names but I don't know how to drop all the stuff after the last letter of the players first name.
Bookmarks