Hi there. First time poster!
Found this forum while searching google for help.

I have a list of names first, last and sometimes middle initial. I need to separate them into 3 columns. Getting last name was easy, seperating on the comma. However I need to get Middle Initials out, where present. The problem is that some of the names on the list have 2 names like "Mary Beth", so I cant just split again on space. My sheet has 16k rows, so manually splitting is out of the question. Does anyone have an easy fix for this?
I was looking for a way to say, like, split after space if following data is 1 or 2 characters (some have periods on initial and some dont)?

For example, I need it to work with each of those:
ABBO, KATHERINE M (returns middle Initial M)
ABBOTT, DANIELLE (returns blank column)
ABE, HODAKA PAUL (returns blank column)
ABELLO, RICHARD R. (returns R.)
ABOU-HARB, JAMIL (blank)
ABRAHAM, JENNIFER VOSS (Blank)
Sorry I am an excel noob. Would greatly appreciate any help.