Mararka qaarkood waxaa laga yaabaa inaad u baahato inaad ka soo ururiso magacyada domainka sabab qaar ka mid ah liiska dheer ee URL^(URLs) -yada bogga shabakadda . Boostada ayaa ku tusi doonta sida looga soo saaro magacyada domain URL-yada^{(extract domain names from URLs )} adoo isticmaalaya Microsoft Excel . Tani waxay noqon kartaa mid faa'iido leh haddii aad qorsheyneyso inaad sameyso Fayl Diidmo si aad ^{(Disavow File)}Google ugu gudbiso . Way fududahay, oo waxaad taas ku samayn kartaa iyadoo la kaashanayo qaacidada Excel .

Aynu ka soo qaadno inaad haysatid liis URL^(URLs) -yo shabakadeedyo kala duwan ah, oo aad u baahan tahay inaad soo saarto magacyada domain-ka qaawan (tusaale, thewindowsclub.com). Haddii faylku yar yahay, waxaad taas ku samayn kartaa gacanta. Laakiin waxay noqon kartaa shaqo waqti-qaadasho ah haddii liisku ka kooban yahay boqolaal URLs . Halkii aad ka dhigi lahayd shaqada gacanta, waxaad qaadan kartaa caawinta hagahan, halkaas oo aad ku baran doonto habka aad uga saari lahayd qaybo dheeraad ah URL oo aad hayso magaca domainka oo keliya.

Ka soo saar^(Extract) magacyada domain URL^(URLs) -yada adoo isticmaalaya Excel

Inta badan waxaa jira laba qaacido oo aad u baahan tahay inaad isticmaasho. Qaabka ugu horreeya wuxuu kuu ogolaanayaa inaad hesho magaca domain oo buuxa; oo ay ku jiraan www (tusaale, www.thewindowsclub.com). Midka labaad ayaa meesha ka saari doona www (tusaale, thewindowsclub.com) oo ku tusi doona magaca domainka oo keliya.

1] Ka saar boggaga WWW

Marka hore, fur liiska URL ee ^(URL)Microsoft Excel . Haddii aad ku haysato faylka .txt ama .csv, waxaad raaci kartaa casharkan si aad faylka qoraalka ugu beddesho xaashida Excel^{(convert a Text file into an Excel spreadsheet)} . Markaad hesho liiska, waxaad u baahan tahay inaad sheegto tiir meesha aad rabto inaad ku muujiso magacyada domainka. Si ay kuugu habboonaato, waxaad samayn kartaa tiir, oo waxaad u magacaabi kartaa "Domain," ama wax la mid ah. Intaa ka dib, dooro unuga kowaad ee tiirka Domain , oo geli qaacidadan-

=MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3)

Marka loo eego qaaciidadan, unugga A2 waa ishaada, unugga la doortay ee tiirka Domain - ka waa inuu muujiyaa magaca domainka ee WWW .

2] Hel magacyo domain oo wata WWW

Mararka qaarkood waxaa laga yaabaa inaad u baahato kaliya magacyada domain sababo kala duwan. Haddii ay sidaas tahay, qaacidada soo socota ayaa qaban doonta shaqada.

=IF(ISERROR(FIND("//www.",A2)), MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3), MID(A2,FIND(":",A2,4)+7,FIND("/",A2,9)-FIND(":",A2,4)-7))

Tani waxay soo saartaa magaca domain ee hal URL markiiba. Haddii aad rabto inaad ku samayso dhammaan URL^(URLs) -yada , waxaad u baahan tahay inaad raacdo tallaabada soo socota.

Macluumaadkaaga, hawlahani kama soo saaraan dhammaan URL^(URLs) -yada hal mar maadaama aad u baahan tahay inaad ku qeexdo lambarka gacanta ee qaababkan. Si kastaba ha ahaatee, uma baahnid inaad gasho shaqada oo dhan mar kasta. Taa bedelkeeda, waxaad isticmaali kartaa jiirkaaga si aad shaqada u dhameysato.

Dooro unug meesha aad ka codsatay shaqada si aad u soo saarto magaca domainka. Waa inaad ku aragtaa dhibic yar oo ku taal geeska hoose ee midig. Waxaad u baahan tahay inaad gujiso badhanka oo u jiid dhinaca unugyada hoose. Waxaad arki kartaa natiijada markaad jiidato dhibicda.

Ka dib markii aad hesho magacyada domain, waxaa laga yaabaa inaad rabto inaad ku kaydiso xaashi kale duwan. Dhibaatada xigta waa inaadan koobi karin magacyada domain adigoo isticmaalaya Ctrl+C iyo Ctrl+V si toos ah. Inkasta oo aad taas samayn karto si aad u dhejiso magacyada domain ee Notepad ama wax la mid ah, qalad ayaa lagu soo bandhigi doonaa samaynta isku mid ah oo ku jira xaashida xaashida.

Si looga takhaluso dhibaatadaas, waxaad u baahan tahay inaad doorato dhammaan magacyada domain ee aad rabto inaad nuqul ka sameyso, dooro tiir ka duwan ama xaashida faafinta, ballaariso xulashada Paste ee tabka ^{(Paste )}guriga^{(Home )} , oo dooro Values ​​ee hoos yimaada qaybta Qiimaha Paste^{(Paste Values)} .

Waa intaas. Hadda waxaad isticmaali kartaa qiyamkaas ama magacyada domain si aad u qabato shaqooyin dheeraad ah. Waxaan rajaynaynaa in casharkan uu ku caawin doono.

Si aad u sameysid Faylka Diidmada^{(Disavow File)} , waxaad u baahan tahay inaad ku darto qoraalka " domain: " hortiisa dhammaan xayndaabka hadda. Boostada ayaa ku tusi doonta sida loogu daro horgaleyaal unugyo kala duwan oo Excel ah.

How to extract domain names from URLs in Microsoft Excel

Sometimes you might need to collect the domain names for some reason from a long list of webpage URLs. This post will show you how to extract domain names from URLs using Microsoft Excel. This can be useful if you are planning to make a Disavow File for submission to Google. It is quite easy, and you can do that with the help of an Excel formula.

Let’s assume that you have a list of webpage URLs of various websites, and you need to extract only the naked domain names (e.g., thewindowsclub.com). If the file is small, you can do that manually. But it can be time-consuming work if the list contains hundreds of URLs. Instead of putting manual labor, you can take the help of this guide, where you will learn the process to remove additional parts from a URL and keep the domain name only.

Extract domain names from URLs using Excel

There are mainly two formulas that you need to use. The first formula will let you get the full domain name; which includes www (e.g., www.thewindowsclub.com). The second one will remove www (e.g., thewindowsclub.com) and show you the domain name only.

1] Extract domains with WWW

First, open the URL list in Microsoft Excel. If you have it in a .txt or .csv file, you can follow this tutorial to convert a Text file into an Excel spreadsheet. Once you have got the list, you need to specify a column where you want to display the domain names. For your convenience, you can create a column, and name it as “Domain,” or something like that. After that, select the first cell of the Domain column, and enter this formula-

=MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3)

According to this formula, A2 cell is your source, and the selected cell of the Domain column should display the domain name with WWW.

2] Get domain names with WWW

Sometimes you might need only domain names for various purposes. If so, the following formula will do the job.

=IF(ISERROR(FIND("//www.",A2)), MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3), MID(A2,FIND(":",A2,4)+7,FIND("/",A2,9)-FIND(":",A2,4)-7))

This extracts the domain name of one URL at a time. If you want to do the same with all the URLs, you need to follow the following step.

For your information, these functions do not extract all URLs at once since you need to specify the cell number in these formulas. However, you do not need to enter the entire function every time. Instead of that, you can use your mouse to get the job done.

Select a cell where you applied the function to extract the domain name. You should see a small dot at the bottom-right corner. You need to click this button and drag it towards the bottom cells. You can see the result as you pull the dot.

After getting the domain names, you might want to save it in a different spreadsheet. The next problem is that you cannot copy the domain names using Ctrl+C and Ctrl+V directly. Although you can do that to paste the domain names in Notepad or so, an error will be displayed for doing the same in a spreadsheet.

To get rid of that problem, you need to select all the domain names that you want to copy, select a different column or spreadsheet, expand the Paste option in the Home tab, and select Values under the Paste Values section.

That’s all. Now you can use those values or domain names to do further jobs. Hope this tutorial would help you.

To make a Disavow File, you need to add the text “domain:” in front of all the domains now. This post will show you how to add a prefix to a range of cells in Excel.

Related posts

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo rakibo oo loo isticmaalo add-ins gudaha Microsoft Word iyo Excel ee iPadka

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Hagaaji Microsoft Excel furitaanka daaqad banaan

• Fix Excel wuxuu sugayaa codsi kale si loo dhamaystiro ficil OLE

• Dib u eegis buug - Microsoft Excel 2010 Talaabo Talaabo ah

• Si degdeg ah ugu beddelo Xaashiyaha shaqada ee Excel

• Sideen u hagaajin karaa Runtime Error 1004 gudaha Microsoft Excel?

• Sida loo isticmaalo shaqada MATCH Microsoft Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Hagaaji qaladka Excel stdole32.tlb gudaha Windows 10

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Hagaaji Soo Celinta Xogta. Sug dhowr ilbiriqsi oo isku day inaad mar kale gooyso ama nuqul ka sameyso qaladka Excel

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel