Time Saving Utilities - Text to Column become an Expert
The shortcut key to open Text to Columns is Alt +D+E.
In this video, we will learn how to use Time Saving Utilities in Excel
we will learn about Text to Columns in Excel which is often used to Split Cell Values into Multiple Columns.
Download Text to Columns in Excel Practice File: https://drive.google.com/file/d/1ZpHI...
What is covered in this Text to Column:
1. Split Names into the First Name and Last Name
2. Split Email Ids into Username and Domain Name
3. Convert Invalid Date Formats into Valid Date Formats
4. Convert Text to Numbers
5. Extract First five Characters of a String
6. Extract First five Characters of a String with leading zero
7. Convert Numbers with Trailing Minus Sign to negative numbers
This is free of cost Advanced Excel Training!
I will also teach you Advance Array in Excel, Simple VBA to Advanced, and more!
Stay tuned
We hope you learn more!
If you want to learn Advance Excel, Array, VBA simple to Advance with a sample workbook without paying any cost this channel is for you please subscribe to my channel. I just uploaded a video that will help you learn Advanced Excel, kindly go and watch all the videos till the end. Do not forget to subscribe. If you like videos please like, share, and support our channel.
A playlist is mentioned below: -
Custom Formatting Tips - Simple to advance (Eng): • Custom Formatting Tips - Simple to ad...
Custom Formatting in Excel (Simple to Advanced) Hindi: • Custom Formatting in Excel (Simple to...
Time Saving Utilities- Paste Special in excel (Eng): • Time Saving Utilities- Paste Special ...
Time-saving utilities- Paste Special in excel In Hindi: • Time saving utilities- Paste Special ...