I know there is a way to do this, but I can't remember how! I have one cell (actually, thousands of cells) where the first name is listed and then the last name. I want to reverse the text so the last name appears first, and then the first name appears last, in the same cell. That way, I can alphabetize the columns by last name.

Does some one know the formula for this?

Also, I know it would be better to separate the first and last name into individual cells but that's not how my client wants it. Thank you in advance!

GSG