Hi everyone,
I have a column of proper names, some of which have middle initials and
some of which do not. I am trying to get them into columns of | first
name | MI | Last Name |. The problem is that excel seperates them into
three columns with the last name in the middle column for people
without middle initials, and the last name in the third column for
people with middle initials. I would appreciate any help you excel
experts could give me.