Sorting names in a range

[Guest]

Just wondering if this is possible...
I have a range for names a1 - a10
I want to put name in the cells "firstname lastname"
Is there a way to have the names put in the way specified and be able to
sort them from the last name?
Is there a way to check a string to a space?
With the variable of the first name being different lengths, can you use the
space after the first name as the marker to choose the next letter (the first
letter of the last name) and use this to sort the names in the range?
Or am I way off base and there might be an easier way.

Thanks for any help.

John

 

[Ragdyer]

One way is to add a "helper" column, where a text formula will extract the
last name, and you then sort the 2 columns, using the "helper" as the sort
key.

This will work for 2 names, or in reality, the text after the first space in
the string:

=MID(A1,FIND(" ",A1)+1,50)