Many people find the process to rework phone number in excel rather challenging, particularly if they don't often deal with paperwork. However, these days, you no longer need to suffer through long tutorials or wait hours for the editing app to install. DocHub allows you to change documents on their web browser without installing new applications. What's more, our powerful service offers a full set of tools for professional document management, unlike numerous other online solutions. That’s right. You no longer have to donwload and re-upload your forms so often - you can do it all in one go!
No matter what type of document you need to alter, the process is simple. Benefit from our professional online service with DocHub!
Oh you okay so we need to remove the parentheses in the dashes so you just have one clean set of phone numbers um so youamp;#39;re literally going to highlight your column so in my case itamp;#39;s column a and if youamp;#39;re on a Mac youamp;#39;ll do command F if you are on a PC you will use ctrl s command F we want the Find and Replace option so first weamp;#39;re going to find the open parenthesis and literally replace with nothing youamp;#39;re not going to put anything in this field youamp;#39;ll do replace all weamp;#39;re not oh I had a space in front of the parenthesis a very careful with that replace all done it replaced 18 instances now weamp;#39;re gonna find the closed parenthesis replace all replaced 18 instances weamp;#39;re gonna find that - replace all place 18 instances you know the problem here is in this format there was an open parenthesis it closed parenthesis space and then the first three digits the number a - in the last four digits to clear that spa