I have a column with the Middle Initial and Lastname(L Doe). How do I
copy the middle initial and lastname, to seperate columns? I was going
to get the leftmost characeter, but some of the cells only have the
lastname in them, there is no middle initial.

Thanks