I have a column of names, each with first and last. Instead of editing each cell to manually add a last name column (hundreds of names) beside the first, is there a way to sort using the second word of the column?

Name
John Thompson

Is there any way to sort for the first character following a space, or something like that? Just hoping there's some way I can do this without grunting through each cell for almost a thousand Thanks for any help!!