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