With DocHub, you can quickly wipe out formula in excel from any place. Enjoy capabilities like drag and drop fields, editable text, images, and comments. You can collect electronic signatures securely, add an additional layer of defense with an Encrypted Folder, and work together with teammates in real-time through your DocHub account. Make changes to your excel files online without downloading, scanning, printing or sending anything.
You can find your edited record in the Documents tab of your account. Create, send, print out, or turn your file into a reusable template. With so many robust tools, it’s easy to enjoy seamless 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
