Hi, Thanks for responding. Here is what I am trying to do:
Joseph Lee Horling Lee =MID(I54,FIND(" ",I54)+1,FIND(" ",I54,FIND(" ",I54)+1)-1-FIND(" ",I54)) Thats where the Lee pops up next to my full name after doing the formula. Then I would like to change the Lee in that same cell to...