According to Wikipedia, Microsoft Excel first came to the Macintosh in 1985 and Windows in 1987. Since then, it has become the go-to spreadsheet program for many people (and companies). So many people are exposed to Excel spreadsheets and have a need to create or edit them. But, what if you don’t have any experience […]
How to Use Excel Text to Columns To Separate Addresses
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 Combine Cells in Microsoft Excel
In a previous post we showed you how to separate first and last names into two columns using Excel’s text to columns function. But, what if you want to combine cells? Say you have first and last names in two columns and you really want them together in one? Here we’ll show you how to […]
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 […]