For example, in A1 might be the name:

John Smith or John L. Smith or John Lee Smith

I would like the result in cell B1 to be JS only

Can a function be used? I have come up so far with
"=MID(A1,1,1)&MID(A1,FIND(" ",A1)+1,1)" but it gives me the middle name
initial and leaves out the last name initial

any help much appreciated!!
thank you