I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
I’ve never commented on any RUclips video before, but this video deserves all the appreciation! After spending more than 2 hours trying to figure it, I came across this video and it was GENIUS! Thank you so much!!!!
Oh my god! I can not thank you enough for this. You are a Legend. I am so grateful to have found this video. I spent 4 hours trying to fix it. THANK YOU.
Check this 1. U will be further empowered.I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
Thank u soo much. Searched number of websites on google and videos on youtube but could not find the solution. You solved the issue in 1 & half minute. Thanks.
Thank you very much - I've struggled to come up with the answer to this and you've been the only one who has come up with what turns out to be a very simple solution as it seems to be a well kept secret!
Check this 1. U will be further empowered.I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
Hi, I have spent almost a week trying to convert my text to date, thanks for saving my project and day. Thanks. I have watched some many videos on youtube but you killed for me. Thanks again
Check this 1. I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
Thanks for this - extremely useful solution. I use it for budgeting purposes, and I struggled to find a good fix to formatting dates that are in different forms.
I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
Thanks the tip - awesome. I could not figure out why when I pasted as value into a date column I got date as text but when I typed it , it went in ok. While all I needed to fix the problem is what you showed med her - huge thanks from my side
You are fantastic! I have been trying to figure this out myself for a day and your video made me happy yet annoyed of myself too! 😅 I should have watched your video one day ago.
I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video..
If this video has solved your problem consider supporting my channel by pressing the THANKS Button above.
Thanks 👍🏻
No solved my problem ,,,can you give Rs40 now.
Bro, I've spent almost 2 hours trying to format my file, I cannot believe it was that easy! Thank you so much!
I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
Me too 😅
Same with me. Feel so useless now 😅
You have no clue how much efficiency this 1 minute video is going to add in our lives! 😅 Thanks a lot!!
LOOL i just told my friend exactly the same thing !! definitely the result is rewarding :)
FINALLY someone answers an excel question with a short, to the point video. THANK YOU
I’ve never commented on any RUclips video before, but this video deserves all the appreciation! After spending more than 2 hours trying to figure it, I came across this video and it was GENIUS!
Thank you so much!!!!
Oh my god! I can not thank you enough for this. You are a Legend. I am so grateful to have found this video. I spent 4 hours trying to fix it. THANK YOU.
Very important information ,i have spend many hours to do this.....thanks 👍
Glad it was helpful!
You are a lifesaver! I have been doing this manually for 100s for data entry. Thanks, I appreciate it!
I have struggled with this for years and really appreciate this video. It fixed it in less than a minute. Thank you so much
Check this 1. U will be further empowered.I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
Thank you!! A life saver, I was going crazy without being able to format the date to a value I can use filters on!!
Seriously, i was spending 4-5 hrs to just figure out how to format this date issue...u just solved it within 1 minutes.....thank you so much... :)
TWO WORDS FOR YOU: THANK YOU
My gf spent multiple weeks trying to fix this and this quick tutorial helped us out. Like
THANK YOU, THANK YOU, THANK YOU. I searched for 1 hour until I found your video.
You are welcome!
Thanks bro bht easy way me bta dia 👌👌
Thank you so much...been sitting with this error for 1 hr
Thank u soo much. Searched number of websites on google and videos on youtube but could not find the solution. You solved the issue in 1 & half minute. Thanks.
Man you have saved my life. 2 freaking hours!!!
Happy to help! 😊
Thank you very much - I've struggled to come up with the answer to this and you've been the only one who has come up with what turns out to be a very simple solution as it seems to be a well kept secret!
Glad I could help!
@@MITutorials thanks so much. This video was so helpful.
Thank you so much for this video, my IT department couldn't figure it out, so thank you!!
wow ! That's Great to hear!
Thank you so much..you are a savior..I used to take 45mins to manually change the format using f2 key..now it took hardly a min..thank you 😊
Check this 1. U will be further empowered.I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
I don't know how to thank you. This really helped me. 👍👍👍
Wah bhai wah gajab
You solved my problem in which got stucked for 1.5 hours thanks bro
Thank you, I don't comment a lot, but this seriously helped 😊😊
Omg thank you! all other videos and instructions did not mention this. Life saver!
No worries!
,I was doing and searching for 2hours but unable to do finally got good video it's really helpful.. thank you bro ..
Thanks dear I faced such problem many times. Now I got solution.
Hi, I have spent almost a week trying to convert my text to date, thanks for saving my project and day. Thanks. I have watched some many videos on youtube but you killed for me. Thanks again
Check this 1. I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
OMG, thank you. You solved my problem. Couldn't figure out why cell formatting wasn't doing anything! This worked!
I spend 1 hour for USA format.... I was missing that "Text To Column" Step............. Thanks alot.... I shared your video with others as well...!!
Great to hear!
You just brought resolution to battle I have been fighting with Excel for the past 2 days. Thank you!!!!
THANK YOU VERY MUCH. CUSTOM NOT WORKED BUT TEXT TO COLUMNS WORKED
Thank you so much brother. You've saved me hours for this. Appraciate it!
Thanks Bro! Will support you after I pay off the student loans I took on paying for the people who are supposed to be teaching me these things!
Hahaha 🤣
just saved an hour of my life thank you.
Bro I hve wasted 4 hours to Correct this no video is available but after seeing in your I hv changed in within 30 seconds only.
God bless you dear
superb trick. never thought this was possible in a few seconds.
Very helpful. It took my whole day and still didnt manage to find the reason. Thanks alot
You're welcome!
Thanks for this short clip fixing this issue. Spot on. Follow this exactly and its sorted.
Thank you very much, I've spent 4 hours to do that !!!
Glad it helped!
I have 7000 lines of data with error in date where I could not use Vlookup function. Your tutorial saved my life. Thanks
Genius!! i've struggled with this for so long!!
Saw many videos but finally u made my struggle successful.... Thank you so much 🙏🏻
OMG i was struggling for this problem today the whole day! and i searched for other videos but it doesnt work. thxxxxx for teaching me!
as always...where profi courses fail, random dude from India saves our lives... I salute you and BIIG THANKS :) :)
My pleasure
You saved my life.. I was like what I am doing !! Arghhhhh! but thanks to you.
You are great 👍👍
Glad I could help!
thank you soo much for this useful information in a short and simple way !!!
The amount of time you just saved me is ridiculous!!!! Thanks!!!!!!
simple, sweet and to the point video
Thanks for this - extremely useful solution. I use it for budgeting purposes, and I struggled to find a good fix to formatting dates that are in different forms.
The only video I felt like leaving a thank you message. Thanks for the help brother you saved me so much time.
Bro, From my head was coming smoke bcz fixing problem, but you saved my time , thanks
I browsed the entire internet only to find my solution here. Thank you so much!
Oh my dear ! God bless you. Your video is quick, clear, simple. EXCELLENT... I was scratching my head big time. THANK YOU SO MUCH
I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video.
you deserve a like and a lifesaver dude
Thanks a lot........ I have been struggling with this problem since quite a long time.
You're welcome!
Thank you. Found this at the right time.
I knew i wld find this on youtube bcoz of marvels like u..thnx boss..
Very effective lesson.
Thank youuuuu soo much dear...
As I was weekly make Reports and suffering from these date formet issues.. Today you Resolve my problem. Thank you
Thanks! Better than all of the official Microsoft guidance.
Thank you very much, I was changing each cell at a time, it was going to take me a lifetime lol.
Thank you.
Thanks the tip - awesome. I could not figure out why when I pasted as value into a date column I got date as text but when I typed it , it went in ok. While all I needed to fix the problem is what you showed med her - huge thanks from my side
Thank you!! This is short and informative!
Thank you so much, saved me from the trouble
Super helpful, just saved me at least a day of headaches with some complex Excel sheets!
Thank you very much for such a simplified video
You are welcome!
Among all the videos, it was the best
Thanks .... Simple & Accurate solution.. I was looking for...
Happy to help
Dude, freaking genius! Thank you so much!
Thanks a million. You deserve a Nobel peace prize
Thank you so much buddy.. I was just missing one of the components. It really helped.
You're welcome!
Thank u so much bro.. Couldnt find this elsewhere..
Thank you, you saved so much of my time
Thank you for sharing. Your instructions was simple, short and straight to the point. Thanx
Super bro. I was so much in need for this trick. Appreciate your work ❤️
You are fantastic! I have been trying to figure this out myself for a day and your video made me happy yet annoyed of myself too! 😅 I should have watched your video one day ago.
What a short and effective way. God Bless you
Great little tutorial, thanks so much!
Your video solves my problem in a few seconds. Thanks
Thank you man, can't believe it's so easy to do, i've been having this question for over a month!!!! XD
I have really racked my brain a lot going one videos to another. I came across a channel "off to office". Delimiters,fixed width, qualifier, dd.mm.yyyy to dd/mm/yyyy everything have been explained in one single video..
This was useful even today, thanks
Short Crisp and To the Point.. Great work and Thank you so much
Thank you. This is just what I needed!
I was getting anxious but then i found this video. It works. Thanks 👍 😊
Great 👍
Thank you! Yours is the only instruction that was able to solve this for me!
Simply explained, Thanks Bro
Very Helpful, i finally got solution after seen your video, Thank you very much.
Great help for self learner's keep it up
Thank you so much! I was struggling for more than an hour over this issue!!
Thank you so much!! i was struggling with formatting and this made my task easy
Thank you! I thought I new all of this stuff and I couldn't figure out why it wasn't working! THANK YOU!
Amazing, i did in 2 sec 🤩 thanks for helping and sharing 😉
My pleasure 😊
Excellent. Thank you. It saved the day for me.
Great to hear!
Bro thank you i got it after trying 30 min easyway thank you
Brooo you don't know how many hours combine you saved people !1 That's crazy, thank you !
Thank you..you saved my time 👍
Very Usefull Video..Thank You so Much
thank you very much for saving my time and share information
Thank u for the information and to explain in very few time
Thank you it was a great help while checking date in formulas.
You're welcome!
Nice and Easy. Keep up the good work.