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
Here is an example
@bryan06 Please attach input sheet
Its attached below