Dang! I never knew that Excel could be used to code things like creating folders in Windows, itself! This is a game-changer, for game-development! :-) Thank you so very much! :-)

@TheTechTrain

25 күн бұрын

I'm so glad you feel this is a useful thing to know! I hope it helps save you a bit of time in future.

@JadeJohnsonIndustries

23 күн бұрын

@@TheTechTrain Oh, defs! I also see it being loads useful in sorting Voice-Files for games and such into unique directories, based on auditory categories and properties, such as formant, pitch, style, vocal-mode, et-cetera! Thank you so very much!

@TheTechTrain

23 күн бұрын

Really glad to hear that! If there's anything else you're aware of could do with being made a bit more time efficient, let me know and I'll see if I can come up with something. 👍

@JadeJohnsonIndustries

23 күн бұрын

How about how to find and replace text of only a certain colour in, not Word, but PowerPoint?! Also, does this folder trick work in Excel 2021?

@TheTechTrain

23 күн бұрын

The use of a spreadsheet to help with creating the batch file creation of folders isn't just limited to Excel - you could just as easily use Google Sheets. Normal search and replace in PPT would not be able to identify specific colours of text, but I imagine it might be possible to use VBA to achieve that. Quite a niche need though!

Simply great solution. Is there a way to create sub folder simultaneously when main folders are being created ?

@TheTechTrain

25 күн бұрын

Yes, you can, although you'd need to add some additional lines to the Excel sheet if that's how you were creating it. Let's say you have folders named 'A', 'B', and 'C', and inside each of those folders you wanted folders named 'Data', 'Images', and 'Assets'. Here's what you'd need: MD "Folder A\Data" MD "Folder A\Images" MD "Folder A\Assets" MD "Folder B\Data" MD "Folder B\Images" MD "Folder B\Assets" MD "Folder C\Data" MD "Folder C\Images" MD "Folder C\Assets" It is also possible to cut this down using a loop, like this: SET folders=A B C SET subfolders=Data Images Assets FOR %%F IN (%folders%) DO ( FOR %%S IN (%subfolders%) DO ( MD "Folder %%F\%%S" ) ) I hope that helps, but do feel free to ask anything else. (I'm looking forward to when the Discord server goes live and questions like this can be shared more easily).

Does this method also allow for subfolders in each folder? Great tip!

@TheTechTrain

21 күн бұрын

Yes, you can, although you'd need to add some additional lines to the Excel sheet if that's how you were creating it. Let's say you have folders named 'A', 'B', and 'C', and inside each of those folders you wanted folders named 'Data', 'Images', and 'Assets'. Here's what you'd need: MD "Folder A\Data" MD "Folder A\Images" MD "Folder A\Assets" MD "Folder B\Data" MD "Folder B\Images" MD "Folder B\Assets" MD "Folder C\Data" MD "Folder C\Images" MD "Folder C\Assets" It is also possible to cut this down using a loop, like this: SET folders=A B C SET subfolders=Data Images Assets FOR %%F IN (%folders%) DO ( FOR %%S IN (%subfolders%) DO ( MD "Folder %%F\%%S" ) ) I hope that helps, but do feel free to ask anything else. (I'm looking forward to when the Discord server goes live and questions like this can be shared more easily).

If you already have first and last names combined into a single column, then why bother splitting them if all you’re going to do is combine them back together with your formula?