Have you ever had trouble with editing your Excel document while on the go? Well, DocHub has a great solution for that! Access this cloud editor from any internet-connected device. It enables users to Cut initials in Excel files rapidly and whenever needed.
DocHub will surprise you with what it offers. It has robust capabilities to make whatever updates you want to your paperwork. And its interface is so intuitive that the entire process from start to finish will take you only a few clicks.
After you finish adjusting and sharing, you can save your updated Excel document on your device or to the cloud as it is or with an Audit Trail that contains all adjustments applied. Also, you can save your paperwork in its original version or transform it into a multi-use template - accomplish any document management task from anyplace with DocHub. Subscribe today!
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 im going to choose the and then youre 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 im 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