Interested in another approach? Instead of using "text to columns", make a new column with the following formula in it:
=MID(A1,FIND(" ",A1)+1,20)
Assuming your names are in column A, this finds the space in the name and uses text from that point on to fill the new column...