We have a document filled with tons of data. There is one column that states people's names. Some with middle names, some with not. But the problem is it's all in one column.
What we need is a macro that can separate all of these into 3 separate columns.
I have a example of what I'm trying to say attached to this.