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.

Do you want to split a single column of text into multiple columns in your Excel spreadsheet? Using the Text to Column feature, you can choose how to split the column up, fix the width, or split at ...

Column graphs offer a visual representation of data that allows easy comparison between multiple values. Typically, these columns are uniformly spaced, but there are times you will need to group ...

You might know how to use Microsoft Flash Fill to create new content, but you might not know that you can use this feature to parse characters across several rows ...

If you've got a sheet full of truncated cells (with no text wrap) that no one can read, manually clicking column and row headers one by one helps with readability—but it could also take a while.