Whenever you download data from an external ERP system like Oracle, SAP, etc, you can have data that is not formatted the way you and Excel likes.

Sometimes “Date” values are downloaded as “Text”, so you cannot sort in the periodic date format.

No worries!  Text to Columns to the rescue!

Below I show you how to convert this “Text” data into “Excel friendly” data.  Download the workbook to practice this cool trick!

NB: If the dates are not converting properly after you do the Text to Columns, it may be that your computer’s Region formats need changing.

Go to the Region settings in your Control Panel and make sure that the Short Date is in this format: dd/MM/yyyy

DOWNLOAD WORKBOOK

Text to Columns - Dates3

HELPFUL RESOURCE:

MOTH-excel_expert470x63

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Excel Table: Row Calculations One of the most powerful feature of an Excel Table is the use of formulas to calculate its Column contents.  To activate this you need to click in your Table and go to the Table Tools tab in the Ribbon.  From there you simply need to activate the Total Rows check box.This wil...
Text to Columns – Emails If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like:John (john@email.com) ...then you can use the Text to Columns feature in Excel to take out the email addresses and put them in a separate ...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list.A dynamic drop down list expands as the Excel Table expands when new data gets added to it.This is great when you want to have users select from a predefined ...
Consolidate in Excel with the CONSOLIDATE Tool The Consolidate tool in Excel is located in the Data menu and combines values from multiple ranges into one new range.You would use this feature when you have a single text column on the left and the column has many duplicate values.First you need to select a blank cell o...