Telephone numbers

edit

I hope your telephone numbers are considered as text bt Calc (text is left justified while numbers are right justified by default). If they are numbers on their own (i.e. the dashes have been added by cell formatting), there's little you can do, apart subtract 10,000,000 from the numbers.

With text:

• Edit>Find & Replace, check Regular expressions
• in Find, enter ^1-(.*)
• in Replace, enter $1

Press some Find Next and Replace to see if it works right, then Replace All.

The regular expression tries to find a cell containing text starting (^) with 1- and captures the rest (.*). Since there are parentheses around the "rest", this is known as the first capture group. The capture group $1 is the replacement string.

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!