Four Text to Columns tricks you cannot miss in Excel

Text to Columns

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.  🙂

Advertisements

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.