Forum Discussion

ATurner876's avatar
ATurner876
Copper Contributor
Apr 06, 2020

AREA CODE

If I have a column with phone numbers (7-digits only) is there a way I can add the area code without typing it in manually in each cell?

excel
Formulas and Functions
  • Savia's avatar
    Savia
    Steel Contributor
    Apr 07, 2020

    ATurner876 You could use a formula - e.g. ="0800"&A1.  Then copy that column and paste values over the original data.

  • Abiola1's avatar
    Abiola1
    MVP
    Apr 07, 2020

    ATurner876 

     

    Hello, you can easily use Flash Fill. In the caption below, the Area Code are in column A while the Number are in column B. In cell C2, type in all the values in cells A2 and B2.

    Then press Enter on your keyboard. Finally, press CTRL + E. That is all

     

Resources