Many people find the process to blot last name in excel rather daunting, particularly if they don't often work with documents. However, nowadays, you no longer need to suffer through long instructions or spend hours waiting for the editing software to install. DocHub allows you to modify documents on their web browser without installing new applications. What's more, our feature-rich service offers a full set of tools for professional document management, unlike so many other online solutions. That’s right. You no longer have to export and import your forms so frequently - you can do it all in one go!
Whatever type of document you need to modify, the process is straightforward. Benefit from our professional online service with DocHub!
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 iamp;#39;m going to choose the and then youamp;#39;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 iamp;#39;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
