Have your heard about “Text to Columns”? A big icon grouped into Data Tools of Data Tab of Excel? Be your answer Yes or No, you do not want to miss the following tricks that may help you transform data quickly. Check it out.
The Basic but useful one:
Split Text of fixed length into columns in Excel
Two useful tricks:
Convert text date to numeric date in Excel
Convert Trailing minus numbers in Excel
A practical use case:
Separate Names and Emails from Outlook distribution list pasted in Excel
Do you find them helpful? Let me know what you think by leaving your comments. 🙂
wmfexcel 