Whether you are already used to working with excel or handling this format for the first time, editing it should not feel like a challenge. Different formats might require specific apps to open and edit them properly. However, if you need to swiftly remove phone number in excel as a part of your typical process, it is best to get a document multitool that allows for all types of such operations without the need of extra effort.
Try DocHub for streamlined editing of excel and also other file formats. Our platform offers straightforward papers processing regardless of how much or little previous experience you have. With tools you have to work in any format, you won’t have to jump between editing windows when working with each of your files. Effortlessly create, edit, annotate and share your documents to save time on minor editing tasks. You will just need to register a new DocHub account, and then you can start your work right away.
See an improvement in document management efficiency with DocHub’s straightforward feature set. Edit any file quickly and easily, irrespective of its format. Enjoy all the benefits that come from our platform’s efficiency and convenience.
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 a