Parse tool

[bryan06]

So i am trying to split data an reformat the names so it is surname , Intial (title) but it keeps corrupting names and mixing them up any solution i have attached the example i have created

[nagakavyasri]

@bryan06 Please attach input sheet

[bryan06 · Accepted solution]

Here is an example 

[bryan06]

Its attached below