Create Multiple Folders From Excel Data

Рет қаралды 70,220

Officeinstructor

Жыл бұрын

Пікірлер: 20

@Mary-ws4jr 6 ай бұрын

This dudes a f*cking wizard. Amazing tutorial, super easy to follow, and straight to the point.

@Dragonfly5280 2 ай бұрын

So glad I found this! I had 320 folders to create! Saved me hours of renaming them!

@kbvaldez 2 күн бұрын

Saved the day, thanks!

@melvinteo6704 Ай бұрын

this was great. works without requiring admin rights.

@lune1kidi 5 ай бұрын

Guys, if your cells have more than one word(first name, last name, etc) you have to add quotes to it. Example: using the same example that the instructor gave, the first cell should be ="MD """&A1&"""" This will sort it. By the way, great video. Short and objective. Thanks

@SabrinaGarcia-cl2em 3 ай бұрын

Please explain further. The quotes aren't working for me. Thank you kindly.

@dr.mixmatch4561 28 күн бұрын

guys stuff that has slashes in them like / or even anything with things that windows does not let you name a folder the MD will not make a folder those characters are ( \ / : * ? " < > | ). Also, if there is spaces in between words then it will turn them into seperate folders. Hope this helps

@Tuesdayable 24 күн бұрын

Thank you so much, you are so fast to response ❤❤❤😊😊😊

@evilhubert 28 күн бұрын

Thank you kind sir!

@michaelt312 Жыл бұрын

This is witchcraft!! This is awesome!!

@karsonowsky 21 күн бұрын

osom

@brad8644 6 ай бұрын

Clutch, thank you

@2x2lcallingcq 6 ай бұрын

This is so awesome

@jonmunnings5347 19 күн бұрын

Whats the left button i dont see what he clicks to make that appear 😢

@Iestynity 4 ай бұрын

How to get a space in the folder name?

@kedked1847 Ай бұрын

Hi Using quotation marks ensures that the entire folder name, including spaces, is treated as a single argument. Save this batch file and rerun it to create the folders as intended. For example: "MD apple pen_1982622"

@COURSSTATSCHAMBERY Жыл бұрын

Un DOS tres Un pasito pa'lante :-) #bootcfg

@lisafromnewyork 7 ай бұрын

Is there a way to batch move documents on desktop to move into these folders without the standard highlight to move, or cut and paste? For example, if I have a student name JOHN SMITH and I have a lot of various documents in the name JOHN SMITH.

@idealphotography8215 7 ай бұрын

I use autophile to do this. I learned if from this video: kzfaq.info/get/bejne/qNCRlKtny9vKpp8.htmlsi=MIL_mK5J6Gd6IGu-