How can I switch a cell of "first middle last" to "last, first" in excel?
the cells are different some have middle names and some don't. what is the general code.
such as switching from
thomas allen smith
amanda r smith