Guys its not rename its ren. Write ren instead of rename in excel. It should be like ren "previous_name" "new_name" Tip: don't forget to add quotation marks "" Thank me later
If it doesnt work, its because theres spaces in your file name, instead of putting just a space, you need to put quotations as well. Rename "(file name).ext" "(file rename).ext"
Thansk a lot guys, I did like this exemple above and worked perfectly. I was needed to random rename my files, so I used chat gpt to create random names to the files and then I follow the tutorial. Thanks a lot guys, saved me so much time.
This is great I am a total NOOB and after watching this I found the bravery to enter with the CMD prompt for the first time in my 49 year life. I even figured out that to change a file name with a space in it, you can just modify the _cmd.cmd document and put quotes around any entire file name that contains space. Thank you!!!
Very useful and efficient. Thank you, Tharun! Users please note: I used a list of new file names that I had created in Excel, which contained spaces in some of the names. I found that new file names will not write if they contain spaces within the new file name itself. I used find and replace to replace spaces with underscores---SUCCESS!
Thank you broo You made me remind of the OG tech youtubers that used to upload these type of videos during 2015-2018. People like you should exist who do not aim for watchtime but intend on helping people so that our time doesn't get wasted. Much appreciation bro. PS : I had issues with my naming of my burst photographs, not going much deep, you solved it 👍👍
Thank you so much you really helped me. But.. in a different way :D I was using your tutorial because it was easier for me. So I have done everything from a to z but it didn't work. But I changed only last step from your tutorial and I have added quotes (") to the files name. And that quote idea was from a different tutorial, more difficult one : D But when I added quotes it worked like magic. Thank you so much ❤️ P.s.Old name and new name both were in quotes. Also I used ren command instead of a rename
use (") when your file has space ( ) or when you want to rename your file with space( ) *mostly I use underscore(_) for the space ( )* but if your file don't have space ( ) don't want to change with space ( ) so no need to add quotes (")
This video is great However I’m facing a problem, if I rename the file using the above method Excel says it’s corrupt and does not let me open Any solution to tha
If it doesnt work, its because theres spaces in your file name, instead of putting just a space, you need to put quotations as well. Rename "(file name).ext" "(file rename).ext"
thanks for your info.. however, I applied this method to my work and still didn't work.. any idea why the error happened and how to solve it? thanks in advanced
@buster5661 many thanks! I tried different method to generate the files in the folder using an application instead of copy paste from google and apparently it worked. thank you so much for the shared knowledge!
THARUN GANAPATHI thankyou yr ap beleive nh karogay mojah images ki file hi ke rename krnay thay is video say boht a6i help mili thankyou bro Images files (56560)
a bit to fast when you explain the step...but after replay it and pause step by step...its work like miracle....thankyou...help me so much..doesn't work the first try..but then I found my problem...I use space instead underscore in the file name....again....thankyou verymuch...
When I click the arrow on paste it doesn’t bring up paste values it brings us 3 different ones and none of them get it out of the underlined form can you help me
the result will be like tharun.1001 (1).jpg tharun.1001 (2).jpg tharun.1001 (3).jpg tharun.1001 (4).jpg yes it works and softwares can be able to read its as image seq. and you can make use of it, if its your personal work. But you can't rely on the same if you are incorporating this in the production environment.
Bro the cmd didn't worked.... I don't know what went wrong..... I did every step as mentioned In the cmd it run as renaming files, but no results after that.
Great tutorial, but I have a problem at one point. Is there any way to bypass the problem with diacritical marks? Characters such as "ć" "ś" "ź" are changed to completely different characters.
Thank you so much for this video!!! 🥰🥰🥰 It really important for me to prepare my document and file!!! but the problem is that, How to rename all the files which has differences extension (.jpg, .jpeg, .png, .xlsx, .doc, .pdf, ........)??? 😊😊😊
I was able to use this code to rename 40.000 files. But I was never able to get the CONCATENATE to work so I used a different way of combining it. I wrote =A1&B1&C1&D1&E1&F1
This video is great However I’m facing a problem, if I rename the file using the above method Excel says it’s corrupt and does not let me open Any solution to that
Guys its not rename its ren. Write ren instead of rename in excel.
It should be like
ren "previous_name" "new_name"
Tip: don't forget to add quotation marks ""
Thank me later
Thanks for sharing the more optimistic way.
I will pin out comment and let others to try this.
If it doesnt work, its because theres spaces in your file name, instead of putting just a space, you need to put quotations as well.
Rename "(file name).ext" "(file rename).ext"
Thansk a lot guys, I did like this exemple above and worked perfectly. I was needed to random rename my files, so I used chat gpt to create random names to the files and then I follow the tutorial. Thanks a lot guys, saved me so much time.
_cmd.cmd
=concatenate(
man literally stuck in 15-30 min tutorials of others videos and thos 3 min video cleared every doubt
When brain works at GOD mode
This is great I am a total NOOB and after watching this I found the bravery to enter with the CMD prompt for the first time in my 49 year life. I even figured out that to change a file name with a space in it, you can just modify the _cmd.cmd document and put quotes around any entire file name that contains space. Thank you!!!
I have this issues with space... Can u pls explain in more detail
this is from 2023, and your video still, help me a lot, thank you
Very useful and efficient. Thank you, Tharun!
Users please note: I used a list of new file names that I had created in Excel, which contained spaces in some of the names. I found that new file names will not write if they contain spaces within the new file name itself. I used find and replace to replace spaces with underscores---SUCCESS!
even there are spaces, give inside Double quotes. It works
To make it easier select all the files right click and go to rename option and type 01 and enter the button BOOM that's it
Thank you Tharun. We need more NO NONSENSE PEOPLE like you. 😀
@@1979ligesh 😅
Title says no CMD but this is literally a command line. Still very useful and easy to do
You don't want to open cmd, but it only executes in cmd. And also every windows system has cmd right, thats y i mentioned.
Thank you broo
You made me remind of the OG tech youtubers that used to upload these type of videos during 2015-2018.
People like you should exist who do not aim for watchtime but intend on helping people so that our time doesn't get wasted.
Much appreciation bro.
PS : I had issues with my naming of my burst photographs, not going much deep, you solved it 👍👍
Happy to hear that dude. Keep learning.
Thank you so much... Really very very helpful video. I recovered 1000+ photos seeing your video ❤ thanks for sharing the knowledge.
Thank you! Your informative video has saved me a significant amount of time.
This was a very good example, slow down a bit, but this worked exactly to a T. Well Done!
Thank you so much you really helped me.
But.. in a different way :D
I was using your tutorial because it was easier for me. So I have done everything from a to z but it didn't work. But I changed only last step from your tutorial and I have added quotes (") to the files name. And that quote idea was from a different tutorial, more difficult one : D But when I added quotes it worked like magic. Thank you so much ❤️
P.s.Old name and new name both were in quotes. Also I used ren command instead of a rename
Thanks for you comment Mishka. Will pin your comment in comment section. It will helpful for many others.
use (") when your file has space ( ) or when you want to rename your file with space( )
*mostly I use underscore(_) for the space ( )*
but if your file don't have space ( ) don't want to change with space ( ) so no need to add quotes (")
@@foxynight1688 Thanks for your explanation @foxynight1688
This video is great
However I’m facing a problem, if I rename the file using the above method
Excel says it’s corrupt and does not let me open
Any solution to tha
I faced the same problem and got solved by the quotation marks, Thanks all @nikhiljacob7605
C:\Users\ELCOT\Desktop\Apple Fuji>rename _ (197).png _1109.png
The syntax of the command is incorrect. ERROR coming bro
Thank you Brother! It works and really helped me.
what a legend, u saved a lot of hours
VERY helpful! Thank you SOO much! The '_' is important, just in case this is helpful for others if they try double clicking the "_cmd.cmd" file
This is gold thank you very much
That worked perfectly. Thanks man!
If it doesnt work, its because theres spaces in your file name, instead of putting just a space, you need to put quotations as well.
Rename "(file name).ext" "(file rename).ext"
thanks
@@shivakarthiksaichinthala1365 good luck. I tried it and it worked, but I got weird symbols sometimes
thanks for your info.. however, I applied this method to my work and still didn't work.. any idea why the error happened and how to solve it? thanks in advanced
@@rinintaindiani Ill try it again tomorrow and let you know
@buster5661 many thanks! I tried different method to generate the files in the folder using an application instead of copy paste from google and apparently it worked. thank you so much for the shared knowledge!
Thanks tharun. God bless you
Dude, I had to modify the code to replace the name in some mp3 files and disable the antivirus. After that, worked like a charm. Thank you
Thank for your comment. Keep learning
wow...can't believe i made it! wat a great tutorial, thank you so much!
Thanks for your comment dude. Keep learning
Thanks a lot.
U make it so much easy to understand.
Jai Hind...🚩
Thanks a lot bro 🙏🙏 I had to put file extension to 2200 files 🙏
You are welcome vivek
And I'm over here stressing about 47 files lol
Worked like a charm.
Thanks a bunch.
THARUN GANAPATHI thankyou yr ap beleive nh karogay mojah images ki file hi ke rename krnay thay is video say boht a6i help mili thankyou bro
Images files (56560)
amazing idea i can clone in many ways to rewrite codes without actually rewriting them
Thank you Tharun, this is really helpful! Do you know if there is a way to do something similar on a Mac?
Beautiful work..... Thanxs a lot.... Needed this so bad to rename my 10k audio files.... Really excellent work.....
Thanks dude. Have a great day
but i cant, how you did, please explain
Gajab🙌
You are an ANGEL
Thanks a ton, from Bangladesh
Superb !!! Thanks alot friend !
Thanks a lot for giving such a brilliant information
thank you bro you save my life
Time saver. Thanks a lot bro
You made my life simpler
Saved me hours of work. Thanks!
Thank you so much ...saved my times
a bit to fast when you explain the step...but after replay it and pause step by step...its work like miracle....thankyou...help me so much..doesn't work the first try..but then I found my problem...I use space instead underscore in the file name....again....thankyou verymuch...
You are an ace man!
Excellent Tutorial. Thank you
thank you soo much bro 🤗😉😉😉😉
Excellent. I did it. Thank you very much.
Veryy very helpful, and easy to learn.. Thank you very much
In mine it shows windows is unable to find the file
Please Cross check the filename. And if you could, please send me the screenshot
Thank you so much, you save me.
good job
When I click the arrow on paste it doesn’t bring up paste values it brings us 3 different ones and none of them get it out of the underlined form can you help me
could you pls, send me the screenshot.? to my linkedIn id which i have added in description
very nice ......... thank you so much
Is it possible to do this with Google sheets? I don't own excel...
Works so well, thank you for tip
total outstanding tutorial.
Thanks very much, it is very helpful. GOD BLESS.
wonderful and thank you
when I paste it in excel it's not coming in sequence and I am not to modify it as squeal any suggestions please
Please send me the code on my linkedin. Will have a look
Bro what just select all file by pressing ctrl+a and then rename one file and it will rename all other files in sequence.
the result will be like
tharun.1001 (1).jpg
tharun.1001 (2).jpg
tharun.1001 (3).jpg
tharun.1001 (4).jpg
yes it works and softwares can be able to read its as image seq.
and you can make use of it, if its your personal work.
But you can't rely on the same if you are incorporating this in the production environment.
Don't know if you will read this comment or not but...
Doesn't work on Win 11 Pro
My current Version of Win 11 is - Latest Version of 22H2 [May]
Thanks, bro
It is very helpful to me
Thanks foe your feedback dude
Thanks a lot buddy.. relly helpful.
Hi Tarun thanks for sharing the information with us but mine is not working cmd is giving some error
Thank you.
Awesome Trick
best one so far# life saver
Great bro thank you so much. before your video i have wasted my 3 hr.
Yeah thanks for your valuable feedback. 🤗🤗🤗
Great tips sir most helping sir ..Thanks a lots sir
One doubt bro
Do we have to delete this _cmd.cmd file after use?
can we name the file xyz.cmd for other folders? (xyz being just an example)
I can use any name. Only .cmd is important.
After rename even if you deleted or not deleted no problem
@@THARUNGANAPATHI thank you bro 👍😊
@@THARUNGANAPATHI one more doubt bro
Can we rename folders using the same?
@@MiKs_Stuff yes you can do
Brilliant, you are a star!!
🤣🤣🤣 keep learning buddy
very good bro, helps me a lot
So many thanks to you 🙏
Bro the cmd didn't worked.... I don't know what went wrong..... I did every step as mentioned
In the cmd it run as renaming files, but no results after that.
Ping me on linkenin
Really Nice
Great tutorial, but I have a problem at one point.
Is there any way to bypass the problem with diacritical marks? Characters such as "ć" "ś" "ź" are changed to completely different characters.
Thank you Tharun..
everything works but when i paste it to notepad it doesn't spaced like it did in the video. is there any solution?
Press space in the empty cells before dragging down and concatenating
In Google Chrome I'm getting half of the file names
BLESSSSSSS THANK YOU SO MUCH
followed the exact steps but have not worked out for me yet
How would I change this is they are not in my hard drive but in an external HD?
Same process.
@@THARUNGANAPATHI Thank you for your quick reply! Does this apply to for files saved in a Network Area Storage?
@@erikwilliams7824 if the network storage is mapped as a drive like C D E, it will works.
@@THARUNGANAPATHI You are awesome, thank you for the great content!
@@erikwilliams7824 keep learning
Supper
Hi pls help me when I follow all and click the cmd in the end it’s running but not change anything pls guide me how to do
Sir if can u share the Wtsapp number to contact and understand the video pls sir I need this topic
@@trincoboys5860 contact me on LinkedIn dude. Will help u fix it.
Link in description
@@THARUNGANAPATHI sir I don’t have if it’s ok to have Wtsapp number please sir help me
When I paste values in other column nothing appears but I can paste it anywhere else
Ping me on LinkedIn. Will help you to fix it
Wtf this very helpful, thank you so much Sensei, bhaahhahahh
Why did you paste in the browser?
wonderful !!!!!!!!
thank you so much 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks for your comment dude
Hi, I tried doing this with excel files. Didn't work out. Can you please help.
will it work on excel files? (.xlsx format) nothing happens after i follow the steps .
Hey bro,
Is there any method to rename multiple excel worksheets name in different different excel files at a time,
Yes dude we can do that. But i havent tried with cmd. But i have tried wiith the python.
Thank you so much for this video!!! 🥰🥰🥰
It really important for me to prepare my document and file!!!
but the problem is that, How to rename all the files which has differences extension (.jpg, .jpeg, .png, .xlsx, .doc, .pdf, ........)???
😊😊😊
Its works for all. Just replace the extension in the excel. It works
@@THARUNGANAPATHI sir its not working when i run cmd it not chance the name
@@jetsfullogre162 ping me on linkedin. Will fix it
& what if previous names has spaces...?
if a word has spaces at the beginning, it wont take.
But if it has spaces at the end, it takes.
you are !!! brilliant
Super
thank you , that's was really helpful !!
Thanks dude
i want to transfer pdf to folder by there serial num in bulk ho to do that
Thank u so much it helped me alot in image sequences
Yeah dude definitely. 😊😊
Thanks brother, but My renamed text contains space how can we solve this
damn great skills bro.
Can we change file extension using this same steps ?
Yes definitely we can do
I was able to use this code to rename 40.000 files. But I was never able to get the CONCATENATE to work so I used a different way of combining it. I wrote =A1&B1&C1&D1&E1&F1
Yeah both do the same. Good try dude🥳
This video is great
However I’m facing a problem, if I rename the file using the above method
Excel says it’s corrupt and does not let me open
Any solution to that
Please send me the code on my linkedin. lets see the error
The rename happens
However the file I think is not converted