First Middle Initial Pgi Form

Instructions and help about First Middle Initial Pgi

hello everyone and welcome to my channel today we are going to learn how to separate names using excel here on my examples i have list of full names and what i wanted to do is to separate the last name the first name and the middle initial so how are we going to do that using excel the first thing that you are going to do is to highlight the names that you wanted to separate and then you are going to click data the next step is to go to text to columns and then a pop-up will appear and you need to choose what best describes your data so as for me i'm going to choose the and then you're going to click next and you are going to choose what separates your data in my case it is separated by comma the last name the first name are separated by comma so i'm going to choose comma and click next then click finish so i have now two columns we have the last name the first name and the middle initial so we just need to label the last name and then i want it also to separate the first name and the