DocHub is an all-in-one PDF editor that allows you to strike out last name in xls, and much more. You can underline, blackout, or erase paperwork fragments, add text and pictures where you need them, and collect data and signatures. And because it works on any web browser, you won’t need to update your hardware to access its powerful tools, saving you money. When you have DocHub, a web browser is all you need to make changes in your xls.
Log in to our service and adhere to these steps:
It couldn't be easier! Streamline your document management now 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
