Hi!

I want to arrange a column that has full names in the same cells by the last names in that cell. Without spliting the cells or changing the order of 'first name + last name'. Does anyone know how to do this in the later excel versions?

Disclaimer: In older versions of excel you can arrange by the second word in a cell and so on. I've read all about these ways online. But in the 2019 excel version these options do not exist. At least not where they did. And I cannot find a solution.

Thank you for any help!!