Arrange by last name when names are in the same cell

[Tosterud]

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!!

 

[Michael M]

I don't believe that function ever exsisted as a native Excel option.
I'd suggest there was either a macro, or something like TexttoColumns involved.
Can you provide how you did it in earlier versions ???

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules, especially regarding cross-posting, and then comply with them (i.e. add links here to your posts in other forums). Thanks.