Have you ever had a list of first and last names in a column on a Google Spreadsheet and simply wished that the first and last names were reversed so you could alphabetize the list by last name?
Well, there is a function for that!
=LEFT(MID(A1,FIND(" ",A1&" ")+1,100)&" "&A1, LEN(A1)
Just replace the "A1" for the cell that you want the function to happen in.
Once the names are reversed, copy the column and then paste the values only.
Now you can now sort the column by last name!