Excel 2010 - Changing last name, first name to first name last name

[wbtczn]

Is there functionality in Excel 2010 to convert a cell that has last name, first name to first name last name? For instance:

• Before: Mouse, Mickey
• After: Mickey Mouse

I'm trying to merge data from 2 sources, and the common data between the two is the name. However, it is formatted differently in each data source.

 

[Rick Rothstein]

Give this formula a try...

=MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2)-1)

 

[wbtczn]

Thanks Rick. I was thinking it'd be something along using MIDs and LENs....but then I thought I was just remembering my old BASIC programming days.