Tag Archives: Text to Columns

Extract 6 digits from a string and convert it into date

Got a question about how to extract the date of birthday (DOB) portion from an ID number like 63102400965, where the first 6 digits represent the DOB, so that we could use the date for other calculation.  In this example the DOB … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Number Stored as Text…

It is something basic and commonly seen.  Nonetheless,  it is really important to understand the different behaviors between a number, and a number stored as text, especially if you want to move forward to write effective formula.  This post is intended … Continue reading

Rate this:

Posted in Excel Basic, Formula | Tagged , , | 5 Comments

How unorganized data could drive you crazy!

This is about how to clean up data for a simple VLOOKUP task.  To be more specific, how to separate data delimited by line break in a cell, as you see in the following screen shot. The one who input … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Fixing trouble dates

Different ways to convert dates stored as text or other unrecognized date formats to real dates in Excel. From time to time, we work with dates in Excel files.  Well, if dates were input correctly as serial number, everyone is happy. … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments