Test20Aug2014.xlsx

Ok thanks i tried that formula and it worked on most names, i think my problem might be related to the way i have to input the names in column A.
Ok here is a better way of letting you know what i have to do.

In column A and column B in sheet 2, i copy and paste these names from another site, and this is why the names have OF, RF, LF, 1B, 2B, 3B, SS, etc.
That is the problem i think but i thought the formulas in sheet 2 in columns C, D, E, F, would take of that, but it isn't i guess.
Here is a different sheet that is what it looks like after i paste the names in columns A, B, C.
Also in columns K, L, in sheet 2 is where i paste the info, and then repaste them in columns A, B, C, in sheet 2
I hope this didn't throw everything crazy.
Thanks for your help.