Editing xls is fast and straightforward using DocHub. Skip downloading software to your PC and make adjustments using our drag and drop document editor in a few quick steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and robust features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and deliver records for completion to other people. All of this, combined with a competitive price, makes DocHub the ideal decision to black out last name in xls files with ease.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the security of your information, as we securely store them in the DocHub cloud.
sometimes you get a list of names and theyamp;#39;re not in the order that you want them they might be last name first and then first name last and maybe want to switch that around to do that what you need to do is firstly highlight the column of names then move up to the data Tab and click on text to columns what this does is this splits up the words in there so weamp;#39;ll just leave that as it is Del limited go next and we already have the option clicked here to split them up based on the where the commas are if I take that out you can see that they come back to being together put the comma in they get split up if I wanted to split them even further uh say with these Chinese names where there are three parts I could click on space as well but for now Iamp;#39;ll just split them in half then if I click next and finish theyamp;#39;ve now been split into two columns to get them so that theyamp;#39;re the other way around so that Iamp;#39;ve got Amy atoms in the first um cell I s