#11




Quote:
If doing this a lot, VBA is the way to go though. 
#12




I am not a VBA guy, but how would you do it that is easier than
Enter the formula in the first cell Select the cells in the column you want to change Click Home Fill Down on the ribbon (assuming excel 2010)
__________________
When you have eliminated the impossible, whatever remains, however improbable, must be the truth. Sherlock Holmes 
#13




Correct Name Order. First, MI, Last.
Thank You,
I haven't been able to correctly line up the names though. "Child, A, Julia" would become "A, Julia Child". But I need it to be "Julia, A, Child" Using this formula. =RIGHT(A3,LEN(A3)FIND(" ",A3,1))&" "&LEFT(A3,FIND(" ",A3,1)) I'm not sure how to correct this. 
#14




Fomula would be
=LEFT(A3,FIND(" ",A3,1))&" "&RIGHT(A3,LEN(A3)FIND(" ",A3,1)) 
#15




coreyspeed, I can't get this formula to work.
=LEFT(A3,FIND(" ",A3,1))&" "&RIGHT(A3,LEN(A3)FIND(" ",A3,1)) I still get this value: Child, A, Julia When I switch the LEFT and RIGHT. I get this: julia child, A, I'm trying to get Julia, A, Child. I'm hoping to use this formula for a few hundred names. 
#16




This is pretty basic stuff, but anyway here goes:
=RIGHT(A3,LEN(A3)FIND(",",A3,(FIND(",",A3))+1)1)&", " & MID(A3,FIND(",",A3)+2,FIND(",",A3,FIND(",",A3,1))5)&"," &LEFT(A3,FIND(" ",A3,1)2) That should do it. 
Thread Tools  
Display Modes  

