In a previous post we explained how to separate names using Microsoft Excel’s text to columns function. But, what if your data is a little more complicated, like an address? In this post we’ll walk you through some more advanced techniques with Microsoft Excel’s text to columns function. We’ll be using Excel 2007 for this […]

Have you ever had an excel spreadsheet in which you’d like to split one column into two or more? For instance, say you have a column with names and you want to separate the first and last names into two separate columns. Excel has a built in function called text to columns which enables you […]