Separate name into 3 columns
Posted on 2014-03-26
I have a sheet with the name in Column A like this:
Barnes, Henry L
I need a formula to separate this into three columns: one for the last name, one for the first name, and one for the initial.
Actually (and preferably), I do not need the middle initial. It would be better to pull just the first and last names into a new single column so it looks like this in the new column:
The second alternative is preferred if possible. If not, then I can use the first alternative and just delete the middle initial column after the formula runs and concatenate the first two columns into one.