Here is the formula for that: = “***-****-” & RIGHT (A1,4) Caveat : When you enter the full number in the first column, be sure to use the dashes, which tell Excel to format the numbers as text. If ...