How to Extract Excel through Text file & Transform Date data type | Excel for beginners
#excel #excelshorts #skill91
Checkout Excel Club- https://www.skill91.com/s/store/cours...
Steps To Follow:
Step 1: Go to Data tab and Select Get Data from Text/CSV.
Step 2: Select the text file you want to open in Excel.
Step 3: When PowerQuery opens check for the separator in the file (Usually newer Versions check that automatically)
Step 4: Check for Date Column from the data, click on Transform Data.
Step 5: Right Click on Column head and select change type Using Locale. Change Type Dialog Box Appears.
Step 6: Select Date data type and press Ok.
Step 7: After changing the data type, check for other columns otherwise click on Close and Load.
Step 8: Data has been loaded, save it before you use it.
😍 Why Choose Excel Club By Neeraj Arora? 😍
✅ 155+ Detailed pre-recorded videos highlighting every feature & function of Excel.
✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access
✅ 380+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel
✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.
✅ Real-life use cases of excel that you can use in your job, business, or internship
✅ Certificate from Skill91 that you can highlight in your resume
✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 12500 students who are learning excel with you RIGHT NOW!
Wondering about validity?
Don't worry. Each enrollment is valid for a SOLID 365 days!
No matter if you're a student, professional, or just looking to get started on MS-Excel
Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.
