This is something I thought I knew how to do, but it isn't working.
I have a column in my spreadsheet with names in the Lname,Fname cormat (Example: Smith,John A)
Say this data appears in cell A2. I thought the way to get is was <=RIGHT(A2,(FIND("",A2,1)-1))&" "&LEFT(A2,(FIND(",",A2,1)-1)) >...