Not to be contrary, but since there are *always* 9 digits on the left,
it becomes much simpler. With one of your entries in cell A1, try this
in cell B1:
=LEFT(A1,9)
.... and this in cell C1:
=MID(A1,10,LEN(A1))

Or, to get trickier and put the SSN into typical format, try this in
cell B1:
=MID(A1,1,3)&"-"&MID(A1,4,2)&"-"&MID(A1,6,4)
.... and the earlier mentioned formula in C1.