Tag Archives: Text to Columns

Extract part of text string with delimiter(s)… and more with Text to Columns

In the previous post, we talked about the basic of Text to Columns and focused on “Fixed width”.  In this post, we will continue to talk about three magical things that Text to Columns could do with ease: Extract part … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 2 Comments

Extract part of a text string using Text to Columns

There are many not-so-easily-understood terms in Excel. “Text to Columns” should be one of them.  Probably due to the name of it, Text to Columns is not a common tool for many Excel users.  But indeed, if you know what … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

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