Haddii aad haysatid xaashid xaashi ah oo aad rabto inaad ka abuurto faylal badan^{(create multiple folders)} qiyamka xaashida xaashida ee Excel , waxaad raaci kartaa casharkan. Haddii aad isticmaasho app desktop Excel, Excel Online^{(Excel Online)} , ama Google Sheets , waxaad isticmaali kartaa casharkan si aad u hesho natiijooyin isku mid ah.

Aynu ka soo qaadno inaad haysatid liis magacyo ah oo ay weheliyaan xog kale oo ku jirta xaashida xaashida ee Excel . Dhanka kale, waxaad dooneysaa inaad sameyso faylal ka dib magac kasta oo lagu sheegay tiir. Halkii aad ku abuuri lahayd gacanta, taas oo waqti badan qaadanaysa, waxaad isticmaali kartaa hab fudud si aad hal mar u abuurto faylal badan oo ka yimid qiyamka unugyada Excel . Maaddaama aad kombayutarkaaga hore ugu haysatay app Notepad , uma baahnid wax kale si aad shaqada u qabato.

Kahor intaadan bilaabin, waa inaad ogaataa dhowr waxyaalood oo ay tahay in la nadiifiyo. Aynu nidhaahno waxaad haysaa xaashi ka kooban saddex tiir iyo shan saf. Haddii aad raacdo habkan, waxaad ku dhammaan doontaa abuurista shan fayl, gal kastana wuxuu ka koobnaan doonaa laba fayl-hoosaad. Waa suurtagal in lagu daro ama laga saaro fayl-hoosaadyo badan, laakiin taasi waxay u baahan tahay shaqo gacanta ah.

Waxaanu talaabooyinka ku muujinnay xaashida demo. Si kale haddii loo dhigo, waxaan soo sheegnay tixda A^{(Column A)} , B, iyo wixii la mid ah si loo fududeeyo tillaabooyinka. Si kastaba ha ahaatee, waxaad u baahan tahay inaad sidaas oo kale ku samayso tiir/ saf/unug gaar ah iyadoo loo eegayo xaashida faafintaada. Sida ku cad hagahan soo socda, Tiirka B^{(Column B)} waxa uu noqon doonaa galka koowaad, iyo tiirka C^{(Column C)} , D, iwm., waxa uu noqonayaa fayl-hoosaadyo.

Sida hal mar loo sameeyo faylal badan oo Excel ah^(Excel)

Si aad hal mar uga abuurto faylal badan oo Excel ah, raac talaabooyinkan-

1. Fur xaashida xaashida ee Excel.
2. Midig ku dhufo Safka A^{(Column A)} oo dooro ikhtiyaarka Gelida^(Insert) .
3. Geli MD dhammaan unugyada.
4. Geli \horgale ahaan dhammaan unugyada marka laga reebo Tiirka A^{(Column A)} iyo B.
5. Dooro^(Select) dhammaan unugyada oo ku dheji Notepad^(Notepad) .
6. Dooro meel bannaan iyo isku-darka muuqda ka hor dhammaan C, D, ama tiirarka intiisa kale.
7. Tag Edit > Replace .
8. Geli nuxurka la koobiyeeyay ee Find what box.
9. Geli ku beddelka^{(Replace with)} sanduuqa.
10. Guji badhanka Bedel Dhammaan .^{(Replace All)}
11. Tag File > Save As .
12. Dooro waddo, geli magac leh .bat kordhinta, oo guji badhanka Save .
13. U dhaqaaq faylka .bat meel aad rabto inaad ka abuurto dhammaan faylalka.
14. Laba jeer ku dhufo.

Aynu si faahfaahsan u eegno tillaabooyinkan.

Marka hore, fur xaashidaada Excel . Si kastaba ha ahaatee, waxaa lagugula talinayaa inaad nuqul ka sameyso xaashidan maadaama aad wax yar ka beddesho xaashida asalka ah.

Furitaanka ka dib, waa inaad gelisaa tiir cusub bilowga. Taas awgeed, midig-guji tiirka A^{(Column A)} ee jira oo dooro  ikhtiyaarka Gelida ^(Insert ) .

Hadda, geli  MD  dhammaan unugyada ku jira Tiirka A.

Marka xigta, waa inaad gelisaa ' \’  horgale ahaan dhammaan unugyada Saarka C^{(Column C)} , D, iyo dhammaan tiirarka kale ee aad rabto inaad ku darto. Taas awgeed, waxaad raaci kartaa tilmaantan faahfaahsan si  aad u geliso horgalayaasha dhammaan unugyada Excel .

Kadib, koobiy dhammaan unugyada, fur app Notepad , oo ku dheji halkaas. ^(Notepad)Waa inaad ka saartaa meesha bannaan ee u dhaxaysa Tiirka B^{(Column B)} iyo C, iyo wixii la mid ah. Taas awgeed, koobi karee qaybta ay ku jirto booska iyo\ > tag  Edit > Replace , oo ku dheji  sanduuqa Find what 

Geli \ gudaha  sanduuqa Ku beddel ^{(Replace with )} , oo guji badhanka  Bedel Dhammaan ^{(Replace All )} .

Hadda, waxaad ka heli kartaa gelitaanka sidan oo kale-

Guji  File > Save As  option, dooro dariiqa aad rabto inaad ku kaydiso faylka, geli magac leh  .bat  extension (tusaale, myfolders.bat), oo dhagsii  badhanka Save  .

Hadda, u dhaqaaq faylka .bat meel aad rabto inaad abuurto dhammaan faylalka oo laba jeer guji. Iyadoo ku xiran inta unug ee aad dooratay, waxay qaadan kartaa 10-15 sekan in shaqada la dhammeeyo.

Waa intaas! Nala soo socodsii haddii aad wax shaki ah ka qabtid faallooyinka.

la xiriira^(Related) :  Sida hal mar loo abuuro faylal badan gudaha Windows^{(How to create multiple folders at once in Windows)} .

How to create multiple folders at once from Excel

If you have а spreadsheet аnd want to create multiple folders from the Excel spreadsheet’s values, you can follow this tutorial. Whether you use the Excel desktop app, Excel Online, or Google Sheets, you can use this tutorial to get the same results.

Let’s assume that you have a list of names alongside some other data in an Excel spreadsheet. Meanwhile, you want to make folders after each name mentioned in a column. Instead of creating them manually, which is very time-consuming, you can use a simple method to create multiple folders at once from Excel cell values. As you already have the Notepad app on your computer, you do not need anything else to get the job done.

Before getting started, you should know a few things that must be cleared. Let’s say you have a spreadsheet containing three columns and five rows. If you follow this method, you will end up creating five folders, and each folder will contain two sub-folders. It is possible to add or remove more sub-folders, but that requires manual work.

We have shown the steps in a demo spreadsheet. In other words, we have mentioned Column A, B, and so on to simplify the steps. However, you need to do the same in a specific column/row/cell according to your spreadsheet. As per this following guide, Column B will be the primary folder, and Column C, D, etc., will be sub-folders.

How to create multiple folders at once from Excel

To create multiple folders at once from Excel, follow these steps-

1. Open the Excel spreadsheet.
2. Right-click on Column A and select the Insert option.
3. Enter MD in all cells.
4. Enter \ as a prefix in all cells except Column A and B.
5. Select all cells and paste them into Notepad.
6. Select space and \ combination visible before all the C, D, or rest of the columns.
7. Go to Edit > Replace.
8. Enter the copied content in the Find what box.
9. Enter \ in the Replace with box.
10. Click the Replace All button.
11. Go to File > Save As.
12. Select a path, enter a name with .bat extension, and click the Save button.
13. Move the .bat file to a place where you want to create all folders.
14. Double-click on it.

Let’s check out these steps in detail.

At first, open your Excel spreadsheet. However, it is recommended to make a copy of this sheet as you are going to make a few changes to the original spreadsheet.

After opening, you have to enter a new column in the beginning. For that, right-click on the existing Column A and select the Insert option.

Now, enter MD in all the cells in Column A.

Next, you have to enter ‘\’ as the prefix in all cells of Column C, D, and all the other columns that you want to include. For that, you can follow this detailed guide to enter prefixes in all cells in Excel.

Then, copy all the cells, open the Notepad app, and paste it there. You have to remove the space between Column B and C, and so forth. For that, copy the portion containing the space and \ > go to Edit > Replace, and paste it in the Find what box.

Enter \ in the Replace with box, and click the Replace All button.

Now, you can find the entries like this-

Click the File > Save As option, choose a path where you want to save the file, enter a name with .bat extension (for example, myfolders.bat), and click the Save button.

Now, move the .bat file to a location where you want to create all the folders and double-click on it. Depending upon how many cells you selected, it might take 10-15 seconds to get the job done.

That’s all! Do let us know if you have any doubt in the comments.

Related: How to create multiple folders at once in Windows.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

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

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo OR shaqada Excel si loo go'aamiyo haddii xaaladdu run tahay

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday