Instantly Create Folders Directly from List in Excel | Excel Tricks

#ExcelTricks #ExcelFunctions #ExcelFormulas
In this MS Excel tutorial, it is discussed how folders can be created from a list in excel with name of each cell.
Excel Tricks
MS Excel
Excel Learning
Excel Formulas
Excel Functions

[@matheusandrade5198]

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 """&B3&"""" This will sort it. By the way, great video. Short and objective. Thanks

[@ushalama1876]

wow thankyou

[@Kurz100]

hero

[@lune1kidi]

Thanks, you are verry cool!

[@ken2k33]

EXACTLY WHAT I WAS LOOKING FOR!! MANY THANKS!!

[@MarkJitroArmada-dv5tw]

I love you bro! hahahaha I saved a lot of time because of this!

[@MoonlitMel]

I do not know you , But forever I will be grateful to you for saving many hours of work.

[@markfly389]

What a time saving blessing! thank you!

[@kamerona]

Great video, short and full of info, thanks so much!

[@mayaa0608]

Thank you very much for this. Very easy to follow.

[@vigneshdhamodharan7846]

Hi bro, can we create .txt files instead of folders... please advice this will be very helpful for me to save hours of work.

[@Vishal_Narale]

Thanks Brother It was too helpful 😁

[@rxpsych]

Unfortunately, I had a problem with the bat program creating 2 folders for every person with a first and last name in one cell. I tried putting quotes " around both names but got some weird symbols in the folder names and it didn't help. Any suggestions? Thanks.

[@karenheflin6574]

Did you get any kind of direction or figure this out? I'm experiencing the same thing. I have names with hyphens and need them to stay together

[@fitmet165]

TRIM WHITE SPACE @@karenheflin6574

[@moulaye7534]

There's a Hero, if you look inside your soul... Thank you. 🙂

[@W3NDIFIED]

Hello, are you able to create subfolders within the folders at the same time?

[@theodora1006]

="MD "& folder name & "\subfolder name"

[@CPanhchakmoni]

you are a life saver

[@NikhilBhutani-k3y]

Helo frnz the video is very useful. but it is creating folder from a to z. how we get folder as per excel list? plz help

[@makarand1985]

Great trick 👏👏👏

[@Rothman5]

i want to create folders like that but want to include several sub folders under each main folder how do I do that?

[@kellyj527]

thanks. just the info i needed.

[@a0fqc]

Can we do this on Macbook?

[@bratovitpierwszy2617]

Please make another video for a window conatining more than one word...

[@EnhantedSaber]

Create one field. Put in " into that field, say cell A1. Put your names in Column B. CONCAT all together... =CONCAT("MD ",$A$1,B1,$A$1) That's for the first name. drag down and you'll get MD "Yukishiro Honoka" Run that in BAT file and you'll get your spaces

[@CandiceFlom]

I entered: ="MD """&A1&""""

[@ZachHayter]

It works. Great job

[@shahriarjabary353]

Hello sir my language is not English and when folders created I can't read the names is that a font problem please help me ty

[@Asli_Minority]

Thanks

[@Rothman5]

wow

[@sayitwithstone4551]

nice, thanks a million

[@mmvjunkmail2385]

Is there a way to make subfolders within the folders it creates? In other words, if i want to create a template folder structure in Windows and I want it to auto-populate the main folders and all folders downstream is that possible?

[@Scott-us2ch]

I accidently create one subfolder. Using "/" the text that follows this is created as a subfolder e.g. MD Car Brands/Ford will create a subfolder named Ford within the folder Car Brands. Hopefully you can play around with it of and work out how to create multiple subfolders

[@akmaldurrani4616]

Great

[@Serenitysounds0007]

Wont work in win 11

[@tudorstoica1578]

thank you

[@khloros17]

You saved us many boring hours!!!

[@vineethnair6542]

What about if a macbook user ? There is notes right

[@mineshpatel1575]

01/04/2024 02/04/2024 03/04/2024 As Above data ho to kaise floder create kare ?

[@taurus12111]

Jeez bro thanks! You really saved me like 8 hours!

[@MadameLalaurie]

Thank you so much! This was so helpful and easy to follow!

[@Hind-zs1pd]

Thank you so much, you helped me a lot

[@nassiriabraham]

Wow, you have unique way with excel excellent, never expected these methods existed.

[@Weddingstoriees]

great brother it help me a lot thank you so much. also can you please tell me can we create text documents with any command like this??

[@imopishakthingom5175]

Thank you!!

[@m85000]

its not directly

[@Talash_e_rah]

Sir is there a method to rename the picture in your pc folder according to the serial numbr of this product in excel sheet

[@Baby-Dreamland-8]

Thank you so much! This was so helpful and easy to follow!

[@akmaldurrani4616]

How about a folder containing a phrase name?

[@MostafaRaouf]

Use _ between the words

[@CandiceFlom]

I entered: ="MD """&A1&""""

[@trannguyenthingoc8936]

@@CandiceFlom thanks a million for your helpful guidance

[@princevarghese9553]

Very useful sir, thank you

[@baebaebae-do1un]

Wow oh my gosh! this is such a helpful trick to use in daily work! : ) I thought I had to visual basic in Excel develop tab, but this way is much much easier than that! if all folders are created, then I can delete the folder BAT file, right? : )

[@MicrosoftOfficeTutorials]

Yes

[@_GB84]

You Sir are a legend

[@sysadminpwti]

If folder names has space then how to apply this formula

[@EnhantedSaber]

Create one field. Put in " into that field, say cell A1. Put your names in Column B. CONCAT all together... =CONCAT("MD ",$A$1,B1,$A$1) That's for the first name. drag down and you'll get MD "Yukishiro Honoka" Run that in BAT file and you'll get your spaces

[@CandiceFlom]

I entered: ="MD """&A1&""""

[@EnhantedSaber]

@@CandiceFlom that works too I guess. I'm just more of a fan of using concat function

[@KZ-wg3jv]

@@EnhantedSaber you made my day!!! Can't thank you enough!!!!

[@EnhantedSaber]

@@KZ-wg3jv sharing the love

[@a3iuuu]

For MacOS?

[@av3dgraphics]

OR WE CAN JUST TYPE MD BEFORE EVERY NAME IN THE NOTEPAD IF THE FOLDERS LIST IS NOT THAT BIG

[@suigyokuakihoshi]

While true, yes - this is an easy way if you have to create a huge list of folders. Example, my company needed to create a folder list of all of our employees. This made it super simple and did what would have taken me at least an hour in 30 seconds. (Did I still get paid for that hour? Yes, yes I did)