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?
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