How do I change "first name last name" to last name, first name" in Excel?

I am editing an Excel document that has info in column A and column B. There are about 5000 rows of documentation. Most of column A has names that are %26quot;first name last name%26quot; and I would like to change them to %26quot;last name, first name%26quot;, however there are some things in column A that are already correct or it's a business name that does not have or need a comma.



Is there anyway to change just the rows that are %26quot;first name last name%26quot; to %26quot;last name, first name%26quot; without messing up anything else???



FYI: nothing in column B needs to be changed.



Thanks!!!
How do I change %26quot;first name last name%26quot; to last name, first name%26quot; in Excel?
Add 2 columns to your list, in the first manually place an X or similar against the names that don't need changing (sorry only way to make this work): in the second cell of second column enter this formula (all one line) then copy down.

=IF(ISBLANK(C2),MID(A2,FIND(%26quot; %26quot;,A2)+1,

LEN(A2)-FIND(%26quot; %26quot;,A2))%26amp;%26quot;, %26quot; %26amp;LEFT(A2,FIND(%26quot; %26quot;,A2)-1),A2)

This should do the bulk of them, manually amend any faults found. Copy and Paste special%26gt;Values when all correct. Delete the two working out columns.
How do I change %26quot;first name last name%26quot; to last name, first name%26quot; in Excel?
Only if you can come up with a programmatical definition of what constitutes a %26quot;first name last name%26quot; entry. Barring that, you can change first last to last, first based on the first space (or last space), into another column. Then manually copy and paste the business names from column A to the new column. Then copy the new column and paste it into column A.



There's no %26quot;recognize this as first name last name%26quot; command in computers.

my myspace

data into xsds