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?
@ATurner876 You could use a formula - e.g. ="0800"&A1. Then copy that column and paste values over the original data.
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