Copy all of the cells from the original column to the first new column. Select the character that divides the data. Depending on your data, this could be a space, a comma, a dash or another character.

One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance, you ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

Splitting the contents of a cell into more than one column manually in Microsoft Excel would take too much time and likely result in errors. Fortunately, the program offers many ways—from built-in ...