One way (assuming only 2 names):

=MID(A1,FIND(" ",A1)+1,255) & ", " & LEFT(A1,FIND(" ",A1)-1)

In article <60ff037be7cc5@uwe, "american" <u22419@uwe wrote:

Hello,

I am a teacher and many times I receive names of students in excel files for
example as John Doe. I would like to know if anyone knows of a way to convert
the name to Doe, John in an easy step so the name can be alphabetized.

If you know please let me know at american @ pressenter . com

Thanks