Peanut33 0 Posted July 24, 2006 Is there a formula in Excel that I can use to convert a player name from LastName, First Name to FirstName LastName in order to allow Projection Pal to convert data to the Compiler? My 2nd site stats have the player name in LastName, FirstName format. I thought maybe there was a =LEFT or =RIGHT formula way to look for the comma and space and then move the everything after to comma space to the front and everything before the comma to the end? Share this post Link to post Share on other sites
sgtgrey 0 Posted July 24, 2006 Did you try clicking on the column heading Last Name, First Name on the Raw page of Projection Pal. There is a drop down menu that works fine. At least for me it did. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted July 24, 2006 Did you try clicking on the column heading Last Name, First Name on the Raw page of Projection Pal. There is a drop down menu that works fine. At least for me it did. Yep, Projection Pal already does this! Share this post Link to post Share on other sites
Peanut33 0 Posted July 25, 2006 Thanks. Sorry, I got confused by all the #NA's on the Projection Pal and didn't realize it would still work when doing the update to the Compiler. Share this post Link to post Share on other sites