Wyatt wrote:Thanks Just wish the players names were listed like this
Bobby Abreu instead of Abreu, Bobby
Dude..you get something for free and you want to complain
Click on the "U" column and up at the top next to "fx" you have a line.
If you paste this in then it should give you what you need:
=MID(A9,FIND(",",A9,1)+1,10)&" " &MID(A9,1,FIND(",",A9,1)-1)
so the very first line in column U would be: Andy Abad
then do a ctrl+C and highlight all the remaining rows in Column U and then do a Ctrl+P. That will propagate the formula to work with all the remaining rows.
Hope that helps.
If you want me to email you my copy PM me