i have names i am copying and pasting from a word document into excel. they
are first and last names, together, each full name in the same cell.

i want to alphabetize the names, but by the last name. however, i want to
keep the first name coming first and the last name, second in each cell.

how can i alphabetize them by the last name when they are written in the
"first name-last name" order??