How to Split Text into Multiple Columns in Excel 2010

I found a very useful feature in Excel that allows you to split your data in one column into multiple columns based on a simple condition. This useful feature is ‘text to columns’ which is a option under the Data menu that allows information in a cell or range of cells to be split into columns.

Below is a simple tutorial to show you how to use this useful Excel feature.


I have a product list that represents product model and serial number. How do I split the product number (Sample A) into two separate columns (Sample B) by using excel? Continue reading