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 […]
How to Use Excel Text to Columns To Separate First and Last Names
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 […]