A
Arch
I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name goes in the middle column which I don't want. I am using TexToColumns. Is there a way to do it right?
Also I want to delete duplicate names. How do I do this ?
Thanks.
Also I want to delete duplicate names. How do I do this ?
Thanks.