To remove dashes and add digits to the beginning of phone numbers (e.g. change 206-456-789 to 1206456789): NOTE: This should be pretty useful in other situations too and should handle small additions better than creating a new cell/column with what you need to add and then Concatenating everything together.