AREA CODE

[ATurner876]

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?

[#2]

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

[#3]

@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