If cell A1 contains (surname)(single space)(single initial)(single
space)(score), the following will achieve what you want:

=LEFT(A1,FIND(" ",A1)+1)&","&RIGHT(A1,LEN(A1)-LEN(LEFT(A1,FIND(" ",A1)+1)))

HTH

"Hayley" wrote:

Sorry it should read
I have Woods T 3/1
i want Woods T, 3/1

Thank you

"Hayley" wrote:

I would like to insert a , with a cell.

i have Wood T 3,1

i would like to have
Wood T,3/1