Here's a formula that I just used that is helpful in grabbing just the last name:
Breaking it down:
The find part of the function looks for the space in the text in cell B2. If it wasn't a space but a comma instead you could use "," instead for that part.
The len(B2) part finds the total length of the string.
By putting those parts together we take the total length, subtract the # in the text string where the space occurs and then we take the right number of characters in the text using the number that was just calculated.
The iferror part added at the beginning just keeps the cell blank if there is nothing to calculate.