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
@kurtrichter17326 ай бұрын
I've been renaming files manually for the last several years -- This is a extremely useful tip for me. THANKS!
@rangs19666 ай бұрын
Please Publish new Videos on Power Query M Language
@trumpexcel6 ай бұрын
Sure... will publish some on M in Power Query
@trumpexcel6 ай бұрын
Thanks Kurt... Glad you found the video helpful 🙂
@IvanCortinas_ES6 ай бұрын
Sensational method with many practical options to do. Thanks Sumit.
@trumpexcel6 ай бұрын
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
@rutaztsai67606 ай бұрын
Bro I cannot imagine the learning way without your videos. This videos always enhance my working efficiency. Thanks a million!
@trumpexcel6 ай бұрын
Thank you so much for the kind words Rutaz... So happy to know that the videos are being helpful 🙂
@danajohnston3 ай бұрын
You are a GENIUS! So simple--you saved me!
@mrsfrenchy36 ай бұрын
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!
@parag26846 ай бұрын
Thanks Sumit. Very useful as I was looking for it since long. You made it without VBA that's really grt8!!
@trumpexcel6 ай бұрын
Glad you found the video helpful Parag 🙂
@rrrprogram86676 ай бұрын
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
@trumpexcel6 ай бұрын
Glad you found the video helpful 🙂
@jonnyostensen24716 ай бұрын
This was really useful. No need for VBA or Python scripts. Thank you!
@trumpexcel6 ай бұрын
Yeah, pretty good trick and needs no programming or automation.
@mayjanedoquila15 күн бұрын
You are a hero. Thanks Bro
@nana-t1w2 ай бұрын
this very usefull! i can rename 3 folders each had more than 300 files less than 30 minutes! THANKYOU VERY MUCHHH
@bjbrooks6 ай бұрын
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.
@trumpexcel6 ай бұрын
Thanks Brian... Glad you found the video helpful 🙂
@TunisianSpring6 ай бұрын
Thank's a ton for these cool tricks!!
@trumpexcel6 ай бұрын
Glad you found the video helpful 🙂
@Pigeon0fDoom6 ай бұрын
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")
@trumpexcel6 ай бұрын
Just got a bit late in making this one 😉
@Pigeon0fDoom6 ай бұрын
@@trumpexcel okay, understandable, have a nice day
@Poolhustla8114 күн бұрын
Thanks so much....amazing time saver
@DarkCobra882 ай бұрын
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.
@abdulsalam9356 ай бұрын
Sir, your methods are simple SUPERB. Thank you.
@trumpexcel6 ай бұрын
Thank you 🙂
@izzatkiswani6 ай бұрын
Thank you !
@Sudharsan-dq6fi6 ай бұрын
Thank you so much for this killer hack...
@trumpexcel6 ай бұрын
Thanks Sudharsan... Glad you found the video useful 🙂
@ghaziehaq3 ай бұрын
bro you are a life saver thanks for the help bro, really helpful
@timmcauley60616 ай бұрын
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!!!~
@trumpexcel6 ай бұрын
Thanks Tim... Glad you found the video helpful 🙂
@russnorcup6 ай бұрын
Excellent video will use your tips again
@trumpexcel6 ай бұрын
Glad you found the video helpful 🙂
@gsuderman6 ай бұрын
Brilliant and simple too. Thank-you
@trumpexcel6 ай бұрын
Glad you found the video helpful 🙂
@da_ta6 ай бұрын
Excellent thanks
@abhishekpandey217905 ай бұрын
Hi Sumit, can you make a video about pasting filtered value in different cell, I mean value in the filter not entire column.
@relax_eglence6 ай бұрын
Thank you very much
@trumpexcel6 ай бұрын
Glad you found the video useful 🙂
@NuliyaAmirafil5 ай бұрын
Very helpful, thank you so much😊🎉
@wiktoriawiki18626 ай бұрын
Excellent!! 😁
@playwithdata_033 ай бұрын
Thanks Sir for this video ❤
@scottlockhart71682 ай бұрын
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
@temyraverdana64216 ай бұрын
Great idea, thanks a lot
@trumpexcel6 ай бұрын
Glad you found the video helpful 🙂
@guptaharsh31834 ай бұрын
Can you Tell the Command to Rename All the File Name along with the Files of the Sub Folders?
@sekharispassion6 ай бұрын
Sir, thanks a lot for the video and xl file.
@trumpexcel6 ай бұрын
Glad you found the video helpful 🙂
@rickyrock3114 ай бұрын
Great!!!, what if i need only pdf in the subfolders to rename it.
@jhankhanajani93146 ай бұрын
Thank you Sumit !!
@trumpexcel6 ай бұрын
Glad you found the video helpful 🙂
@quytngo9203 ай бұрын
Thank bro
@micheltremblay81846 ай бұрын
Thank you, very wise :)
@trumpexcel6 ай бұрын
Thanks Michel 🙂
@chandanlimma34436 ай бұрын
Brilliant
@excelmixture6 ай бұрын
Great 👍
@DKumar-ww3rnАй бұрын
Is it necessary to add extensions like .pdf, .xlsx
@tedmoy6 ай бұрын
Would also show us how to use the Command Prompt to rename folders and also subfolders as well?
@trumpexcel6 ай бұрын
You can rename the subfolders the same way you would rename a file. But for files within sub folders, you'll have to get into with each subfolder and then run the command
@tedmoy6 ай бұрын
thank you!@@trumpexcel
@georgepapaioannou39246 ай бұрын
what if we use power automate instead?
@trumpexcel6 ай бұрын
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.
@chaitanyajoshi690Ай бұрын
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.
@AGENTJAPANNАй бұрын
I'm getting access denied after running the final step and the names are not changing...pls help me sir
@ilanzer-aviv729325 күн бұрын
If I chose the same new name will it automatically add number at the end of the name?
@trumpexcel25 күн бұрын
It would skip renaming that file
@tedmoy6 ай бұрын
You used to have a link where we can donate funds for your coffee budget. What happen to that link?
@trumpexcel6 ай бұрын
It's there in the video description 🙂 Putting it here as well - www.buymeacoffee.com/SumitB
@tedmoy6 ай бұрын
Please keep this available on your videos. ;-)@@trumpexcel
@igboanugosamuel33756 ай бұрын
wonder video,please i will like you to cover topics on power pivot, Dax and Data visualization in your next topic