In this video, learn how to split data into multiple worksheets in Excel, such as separating total sales into quarterly ...

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.

This is the demonstration file to accompany the article, How to split a column using an IF() function in Excel, by Susan Harkins. Search to explore resources We use cookies and other data collection ...