Turn One Column of Data into Two with Excel 2010
While some people that create spreadsheets might think that they are simplifying the process by putting a lot of data into one column, that is usually not the case. Information in spreadsheets is much simpler to manage, especially in large quantities, when you have your data as segmented as possible. This provides more options for sorting and organizing data, plus it will make it easier for your database manager to use that data in their tables if necessary. Continue reading to learn how to split single column data into multiple columns in Excel 2010. Step 1: Open the spreadsheet containing the column of data that you watn to split. Step 2: Click the column heading at the top of the spreadsheet so that the column with the data to be split is highlighted.
Step 3: Click the Data tab at the top of the window.
Step 4: Click the Text to Columns button in the Data Tools section of the ribbon at the top of the window.
Step 5: Click the Delimited option if there is something separating the data that you want to split, like an empty space, or click the Fixed width option if you want to split the data at a set number of characters. Click the Next button to continue.
Step 6: Choose the character that you want to set as the split, then click the Next button. If you are using the Fixed width option, click the point where you want the split to occur.
Step 6: Choose the data format for each of the columns, then click the Finish button to split your column.
If your data did not split correctly, you can press Ctrl + Z on your keyboard to undo the split, then repeat the steps to make any necessary adjustments. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.
You may opt out at any time. Read our Privacy Policy
