With DocHub, you can quickly clean up question in xls from any place. Enjoy capabilities like drag and drop fields, editable textual content, images, and comments. You can collect electronic signatures securely, add an extra level of protection with an Encrypted Folder, and collaborate with teammates in real-time through your DocHub account. Make adjustments to your xls files online without downloading, scanning, printing or sending anything.
You can find your edited record in the Documents folder of your account. Edit, submit, print out, or turn your document into a reusable template. Considering the variety of robust tools, it’s simple to enjoy trouble-free document editing and managing with DocHub.
so I recently received this list of phone numbers and the formatting is kind of messy and I want to clean all this up to make it easier to read so to do that the first thing Iamp;#39;m going to do is select all these cells here Iamp;#39;m going to hit Ctrl H on the keyboard to bring up the find and replace window and I want to find these separator characters here which in this case are dashes and replace those with nothing to get rid of those so Iamp;#39;m just going to put a dash character here and find what put replace with have nothing there and hit replace all and that will replace all those separator characters and you can see we now just have numbers if you have parentheses or spaces or periods between the numbers you can also use the same technique to find and replace those once we do that weamp;#39;re going to right click now hit format cells and since these are all numbers we can then go to special here and choose phone number and that will allow us to apply this nice form
