Copy Mark Phone Number with airSlate SignNow

Manage numbers notice

Here's something that you could potentially have to deal with in a Numbers spreadsheet. Notice I've got this simple list here of names and phone numbers. But the phone numbers are formatted in a whole bunch of different ways. This can be very frustrating. You can see here I've got ones with parentheses, with dashes, with dots. I've ones that actually have no other marks except numbers leading Numbers to think that it's an actual number and not text. So how do you get all these to be one format. Unfortunately there's no easy way to do it. If you've ever dealt with this before and you've been frustrated there's a good reason. There's no special formula function or formatting thing in Numbers that will take care of this. So I want to give you two ways to deal with this. So the first method is going to do the bulk of the work. Not using formulas but just some simple searches. I'm going to copy this entire set of phone numbers here, Command C, Command N to open up a new Numbers document and paste it in here. This is just going to be a temporary document so I'm not worried about formatting or things like that. I'm going to do Command F to find and I'm going to switch to Find and Replace and I'm going to search for the characters I don't want. So starting with the left parenthesis I'm going to hit Replace All and I'm going to replace it with nothing. Then I'm going to do right, Replace All, I'm going to do Space, Replace All, a dash and Replace All and a period, Replace All. You can see now I've cleaned up these numbers completely. The reason I didn't do it here in the main spreadsheet was because I didn't want to, say, replace the spaces in the names. It would replace them throughout the entire spreadsheet. So now that I've cleaned these up a bit I'm going to format these so they look like phone numbers that I want. So I'm going to go over to Cell here and I'm set the Format to be a Custom format. This is where it gets tricky. What I want to do is I want to use these integer formats here. I'm going to set it to be a specific number of digits. So three digits and then I'm going to surround that with parentheses and then a space. Them I'm going to drag another one of these integers here and I'm going to set that to also three digits, a dash, another integer set. Leave this as four digits but I'm going to hide the separator. So you can see now that looks like a phone number. Sure enough, now I get a nicely formatted set of phone numbers there. Now I can go and Copy, go back to this table here and go Edit and then I want to Paste and Match Style. Now...