AREA CODE

%3CLINGO-SUB%20id%3D%22lingo-sub-1286615%22%20slang%3D%22en-US%22%3EAREA%20CODE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286615%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20have%20a%20column%20with%20phone%20numbers%20(7-digits%20only)%20is%20there%20a%20way%20I%20can%20add%20the%20area%20code%20without%20typing%20it%20in%20manually%20in%20each%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1286615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1287892%22%20slang%3D%22en-US%22%3ERe%3A%20AREA%20CODE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1287892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F611794%22%20target%3D%22_blank%22%3E%40ATurner876%3C%2FA%3E%26nbsp%3BYou%20could%20use%20a%20formula%20-%20e.g.%20%3D%220800%22%26amp%3BA1.%26nbsp%3B%20Then%20copy%20that%20column%20and%20paste%20values%20over%20the%20original%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 Replies
Highlighted

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

Highlighted

@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

Abiola1_0-1586260546926.png