I'm afraid I have to disagree with the post from well0549 to some extent.

You'll never catch all possible situations using any automated algorithm, but if you could convert most of them without or errors, you're already halfway.

But I do like the idea of setting up an additional table, or adding some fields to the table, containing just the first and last name. This way, you could at least do some manual corrections and store them for future use.