If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.) i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately... if u can help me out, it would be a tremendous support for my project...
@@trumpexcel sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.) i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately... if u can help me out, it would be a tremendous support for my project...
Brilliant.... I know easy method to copy all the files name in a folder... But i didn't knew how to rename all the files in one go.... Excellent job.. Loved it
WOW! This is absolutely awesome. I sure wish this was available about a year ago. I manually renamed hundreds of files to make everything uniform. I will be making use of this hack. Thank you so much for your videos!
This was very useful, thank you. Windows default method (1), (2) when selecting multiple files with F2 is a let down and this is much more useful, i have a photo folder with hundred of images and this solves the issue right away. much appreciated.
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.) i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately... if u can help me out, it would be a tremendous support for my project...
This was so useful and has streamlined my photography workflow. No need to run my VBA code to create csv files and then Powershell scripts using those csv files as imput!!!! Thank You!!!~
Great tip, love it, really useful. Previously, I've done that sort of renaming using Excel to create the command, but I've always then created a .BAT file. This is much quicker and easier! (And I didn't know you could type "CMD" in the Explorer address bar!). Nice one, thank you.
I needed this 5 years ago! where were you? We had to check a list in excel vs a folder to check if either was complete and change the names of the old files to the new format. about 6000 files. i feel so... so... i dont wanna talk about it. (like and add to playlist "excel to never forget")
@@Pigeon0fDoom sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.) i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately... if u can help me out, it would be a tremendous support for my project...
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.) i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately... if u can help me out, it would be a tremendous support for my project...
Dear Sumit Ji Pl help me for a situation. I have got thousands of excel and word files spread across many folders and subfolders. My object is to open each Word file in old Microsoft Word (very much old version 97 or so), replace a particular font with another, save and close the file. Now I have already prepared a Macro for font replacement in old Wordbasic language. I need your suggestion how to copy all Old Microsoft Word files and paste them in a separate folder. Can method in this video somehow help. I have tried to identify them with the help of File Properties in VBA but many files get left out. I also tried .doc extension but failed because many Word files are created in later versions like 2007 having .doc extension and I can't open those files in later versions because that font is only compatible in old Microsoft Word (97 or so). Pl help.
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.) i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately... if u can help me out, it would be a tremendous support for my project...
That would work too.. this is more of a quick and dirty trick if you want to do it one time. With Power Automate, you can make it a repeatable process.
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
I've been renaming files manually for the last several years -- This is a extremely useful tip for me. THANKS!
Please Publish new Videos on Power Query M Language
Sure... will publish some on M in Power Query
Thanks Kurt... Glad you found the video helpful 🙂
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.)
i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately...
if u can help me out, it would be a tremendous support for my project...
Sensational method with many practical options to do. Thanks Sumit.
Thanks Iván... I learned this recently and it's amazing how much time this can save if there is a need to rename files in bulk
@@trumpexcel sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.)
i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately...
if u can help me out, it would be a tremendous support for my project...
Bro I cannot imagine the learning way without your videos. This videos always enhance my working efficiency. Thanks a million！
Thank you so much for the kind words Rutaz... So happy to know that the videos are being helpful 🙂
Brilliant.... I know easy method to copy all the files name in a folder... But i didn't knew how to rename all the files in one go....
Excellent job..
Loved it
Glad you found the video helpful 🙂
WOW! This is absolutely awesome. I sure wish this was available about a year ago. I manually renamed hundreds of files to make everything uniform. I will be making use of this hack. Thank you so much for your videos!
Thanks Sumit. Very useful as I was looking for it since long. You made it without VBA that's really grt8!!
Glad you found the video helpful Parag 🙂
This was very useful, thank you. Windows default method (1), (2) when selecting multiple files with F2 is a let down and this is much more useful, i have a photo folder with hundred of images and this solves the issue right away. much appreciated.
This was really useful. No need for VBA or Python scripts. Thank you!
Yeah, pretty good trick and needs no programming or automation.
We are looking for a solution for renaming files that have spaces in their name. I found the solution in what you presented.
Thank you very much.😀
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.)
i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately...
if u can help me out, it would be a tremendous support for my project...
Thank's a ton for these cool tricks!!
Glad you found the video helpful 🙂
this very usefull! i can rename 3 folders each had more than 300 files less than 30 minutes! THANKYOU VERY MUCHHH
Thank you so much for this killer hack...
Thanks Sudharsan... Glad you found the video useful 🙂
You are a GENIUS!
So simple--you saved me!
Sir, your methods are simple SUPERB. Thank you.
Thank you 🙂
Very useful and informative
This was so useful and has streamlined my photography workflow. No need to run my VBA code to create csv files and then Powershell scripts using those csv files as imput!!!! Thank You!!!~
Thanks Tim... Glad you found the video helpful 🙂
You are a hero. Thanks Bro
Excellent video will use your tips again
Glad you found the video helpful 🙂
Brilliant and simple too. Thank-you
Glad you found the video helpful 🙂
bro you are a life saver
thanks for the help bro, really helpful
Great tip, love it, really useful. Previously, I've done that sort of renaming using Excel to create the command, but I've always then created a .BAT file. This is much quicker and easier! (And I didn't know you could type "CMD" in the Explorer address bar!). Nice one, thank you.
Thanks Brian... Glad you found the video helpful 🙂
I needed this 5 years ago! where were you?
We had to check a list in excel vs a folder to check if either was complete and change the names of the old files to the new format.
about 6000 files. i feel so... so... i dont wanna talk about it.
(like and add to playlist "excel to never forget")
Just got a bit late in making this one 😉
@@trumpexcel okay, understandable, have a nice day
@@Pigeon0fDoom sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.)
i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately...
if u can help me out, it would be a tremendous support for my project...
@@benjackson6260 are these (word) files in folders, and the pictures in order with the files as well?
Thanks so much....amazing time saver
Thank you !
thank you so much! helped so much!
SUPERB. Thank you
Thank you very much
Glad you found the video useful 🙂
Very helpful, thank you so much😊🎉
Great idea, thanks a lot
Glad you found the video helpful 🙂
Sir, thanks a lot for the video and xl file.
Glad you found the video helpful 🙂
Excellent thanks
Thank you Sumit !!
Glad you found the video helpful 🙂
Great video. What would the command be if you would like to search for two types of files types at once? For example: *.pdf and *.txt
Thanks man!!
Hi Sumit, can you make a video about pasting filtered value in different cell, I mean value in the filter not entire column.
Excellent!! 😁
Thanks Sir for this video ❤
Great!!!, what if i need only pdf in the subfolders to rename it.
Thank you, very wise :)
Thanks Michel 🙂
Great 👍
Thank bro
Brilliant
Can you Tell the Command to Rename All the File Name along with the Files of the Sub Folders?
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.)
i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately...
if u can help me out, it would be a tremendous support for my project...
Is it necessary to add extensions like .pdf, .xlsx
If I chose the same new name will it automatically add number at the end of the name?
It would skip renaming that file
Dear Sumit Ji
Pl help me for a situation. I have got thousands of excel and word files spread across many folders and subfolders. My object is to open each Word file in old Microsoft Word (very much old version 97 or so), replace a particular font with another, save and close the file. Now I have already prepared a Macro for font replacement in old Wordbasic language. I need your suggestion how to copy all Old Microsoft Word files and paste them in a separate folder. Can method in this video somehow help. I have tried to identify them with the help of File Properties in VBA but many files get left out. I also tried .doc extension but failed because many Word files are created in later versions like 2007 having .doc extension and I can't open those files in later versions because that font is only compatible in old Microsoft Word (97 or so). Pl help.
sir, if u are reading this, i need urgent help... im doing a project of providing novels and books to highschool kids... but the online novels are in chapters divided into multiple folders (~1000+ folders), each containing a few images (also in numerical order :- 001, 002, 003 etc.)
i need to combine all the chapter folders into 1 single folder, and still keep the images in order, so that i can just press "print" and be done with a book... at present im having to manually extract each chapter and print it seperately...
if u can help me out, it would be a tremendous support for my project...
what if we use power automate instead?
That would work too.. this is more of a quick and dirty trick if you want to do it one time. With Power Automate, you can make it a repeatable process.
I'm getting access denied after running the final step and the names are not changing...pls help me sir
wonder video,please i will like you to cover topics on power pivot, Dax and Data visualization in your next topic