Have you ever struggled with editing your Xls document while on the go? Well, DocHub has a great solution for that! Access this online editor from any internet-connected device. It allows users to Negate phone number in Xls files quickly and whenever needed.
DocHub will surprise you with what it offers. It has robust functionality to make any changes you want to your paperwork. And its interface is so simple-to-use that the entire process from start to finish will take you only a few clicks.
As soon as you finish modifying and sharing, you can save your updated Xls file on your device or to the cloud as it is or with an Audit Trail that contains all changes applied. Also, you can save your paperwork in its initial version or transform it into a multi-use template - accomplish any document management task from anyplace with DocHub. Subscribe today!
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 youre literally going to highlight your column so in my case its column a and if youre on a Mac youll 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 were going to find the open parenthesis and literally replace with nothing youre not going to put anything in this field youll do replace all were not oh I had a space in front of the parenthesis a very careful with that replace all done it replaced 18 instances now were gonna find the closed parenthesis replace all replaced 18 instances were 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 space youre gonna do the same thing find space and replace with nothing replace al