Liisaska lambarrada telefoonku waa kiis aad ugu badan oo leh tifaftirayaasha Microsoft Excel . Marka laga hadlayo nambarada telefoonada dhulka iyo kuwa ajnabiga ah, ku darida koodka waddanku waa muhiim haddii kale taleefoonku waligii ma awoodi doono inuu si sax ah u garaaco lambarka. Maqaalkan, waxaan ku tusi doonaa sida loogu daro lambarka dalka^(Country) ama goobta^{(Area Code)} liiska lambarka taleefanka^{(Phone Number List)} ee Excel .

Ku dar Koodhka Dalka^{(Add Country)} ama Goobta ^{(Area Code)}Liiska Lambarka^{(Phone Number List)} Taleefanka ee Excel

Si loogu daro koodka waddanka/aagga liiska lambarka taleefanka ee Excel , waxaad isticmaali kartaa qaacidada horgalayaasha ah ee fudud, si kastaba ha ahaatee, tani waxay shaqaynaysaa marka koodhka waddanka/ aagga uu la mid yahay dhammaan lambarrada telefoonnada ee liiska.

Haddaba, ka hor intaadan ku darin koodka waddanka/aagga horgale ahaan, hubi inaad u habayso sida ku cad goobta isticmaaluhu joogo.

Ereyga ku daraya koodka waddanka/aagga liiska lambarka taleefanka ee Excel waa sida soo socota:

="<area code>"&<first cell from which you need to add the area code prefix>

Halkee,

• <area code> waa koodka aagga lagu daro daba-gal ahaan.
• <first cell from which you need to add the area code prefix> waa unugga ugu horreeya ee leh lambarka taleefanka kaas oo aad u baahan tahay inaad ku darto lambarka goobta.

Intaa ka dib, waxaad isticmaali kartaa ikhtiyaarka Buuxi ee ^(Fill)Excel si aad hoos ugu dhigto qaacidada ilaa lambarka taleefanka ee u dhigma aad rabto inaad ku darto koodka horgalaha waddanka/aagga.

Sida loo dhejiyo xaashida Excel ee Blog kaaga^{(How to embed an Excel Sheet on your Blog)}

Tusaale ahaan. Aynu ka soo qaadanno liiska lambarrada taleefannada xaashida Excel oo ka bilaabmaya unugga A3 ilaa unugga A12 . Waxaad u baahan tahay liiska lambarada taleefanka ee dib loo eegay oo leh summada aagga “110” oo ah horgalaha safafka u dhigma ee tiirka C. Nidaamku wuxuu ahaan lahaa sidan soo socota:

Formula: ="110"&A3

Geli caanahan unugga C3 oo guji meel kasta oo ka baxsan unugga.

Waxaad ku ogaan doontaa lambarka taleefanka gacanta ee dib loo eegay ee C3 kaas oo u dhigma lambarka taleefanka asalka ah ee gacanta A3.

Hadda dhagsii unugga C3 mar labaad si aad u muujiso ikhtiyaarka Buuxi .^(Fill)

Guji dheerka^(Long-click) dhibicda ku taal geeska hoose ee midig ee unugga C3 oo u jiid unugga C12 .

Waxaan rajaynayaa inaad casharkan u fududayso in la fahmo.

How to add Country or Area Code to a Phone Number List in Excel

Lists of phone numberѕ are a very common case with Microsoft Excel editors. In the case of landline and fоreign phone numbers, adding the country code is important or the caller would neνer be able to dial the number right. In thіs post, we will show yоu hоw to add Country or Area Code to a Phone Number List in Excel.

Add Country or Area Code to a Phone Number List in Excel

To add country/area code to a phone number list in Excel, you could use the simple prefix formula, however, this is valid when the country/area code is the same for all phone numbers across the list.

Thus, before adding the country/area code as a prefix, make sure you arrange them as per the location of the user.

The syntax for adding country/area code to a phone number list in Excel is as follows:

="<area code>"&<first cell from which you need to add the area code prefix>

Where,

• <area code> is the area code to be added as a suffix.
• <first cell from which you need to add the area code prefix> is the first cell with the phone number from which you need to start adding the area code.

Thereafter, you could use the Fill option in Excel to pull down the formula till the corresponding phone number you wish to add the country/area code prefix to.

How to embed an Excel Sheet on your Blog

Eg. Let us assume a list of phone numbers in an Excel sheet starting from cell A3 to cell A12. You need the revised list of phone numbers with the area code “110” as the prefix in the corresponding rows of column C. The procedure would be as follows:

Formula: ="110"&A3

Enter this formula in cell C3 and click anywhere outside the cell.

You will notice the revised phone number in cell C3 which is corresponding to the original phone number in cell A3.

Now click on cell C3 again to highlight the Fill option.

Long-click on the dot on the right-bottom corner of cell C3 and drag it to cell C12.

I hope you find this tutorial easy to understand.

Related posts

• Sida loo tuso ama loo qariyo Liiska foomamka marka aad ku qorayso Excel

• Sida loo beddelo Serial Number taariikhda Excel

• Sida Loo Sameeyo Liiska Hoos-u-dhaca ee Excel

• Soosaaraha Nambarka Random ee Excel: Sida iyo Goorta La Isticmaalayo

• Sidee loo helaa Lambarka Taleefoonka Virtual?

• 25 Bixiyaha Nambarka Taleefanka ee Bilaashka ah ee ugu Fiican

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo sameeyo Gmail Account la'aanteed Xaqiijinta Lambarka Taleefanka

• 3 siyaabood oo aad ku heli karto Nambarka Taleefanka Gubida Aan la garanayn ee taleefankaaga casriga ah

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Ku samee Lambarka Taleefanka Dheeraadka ah ee Android Smartphone ama iPhone

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Samee xisaabaadyo badan oo Gmail ah iyada oo aan la xaqiijin lambarka taleefanka

• Ku beddel magacaaga, lambarka taleefankaaga iyo macluumaadka kale ee Koontada Google

• Sida Qofka Loogu Helo Instagram Nambarka Taleefanka

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay