Question: I have a worksheet in which area codes (for example
123) are stored in column A and phone numbers (for example 456-7890)
in column B. I want to combine them as "123-456-7890" in a
Answer: Enter the formula =A1&"-"&B1
in cell C1, then copy this formula to the cells below as many times
as you have phone numbers.
Now you have the combined phone numbers, but only as formulas. If you
want to convert them to literal values, select the new formulas and
copy them with Edit > Copy to the clipboard. Leave the
formulas selected and execute the command Edit > Paste Special.
Switch the option "Convert formulas to values" on and
click on OK. Now your worksheet contains the phone numbers as literal strings.