You have a datasheet having values in a single column that you want to separate or split the values into multiple columns for to use the data. This articles will guide you about how you can split cell value into multiple cells in Excel.
Split text from one cell into multiple cells You can take the text in one or more cells, and distribute it to multiple cells. This is the opposite of concatenation, in which you combine text from two or more cells into one cell. Tip: You will need to have blank cells where you want the split data to go. So it is a good idea to insert the columns before you follow the steps below. Open the Excel spreadsheet containing the data that you want to split. Highlight the cells containing the data that you wish to split. Click the Data tab at the top of the window.
By following the steps listed in this article, you could easily split cell value into multiple cells by just a few clicks. This article can help you only if all of the cells that you want to split have data separated using the same delimiter i.e using the same character like space, special characters (>, <, -, comma), etc. So, Let’s get started but, first select all the cells or column that you want to split.
Step 1: Go to Data in the menu then Text to Columns, the pop-up wizard will help you through the process.
Step 2: In the wizard first select Delimited and click Next button.
Step 3: Select appropriate Delimiter type like a comma, tab or insert if the special character by which your text is split, click Next button.
Step 4: In the next page select type of Data format for new columns, you can see the preview in Data Preview window.
Step 5: Press button beside the input box of Destination label, it will collapse the wizard to let you select the columns for new cells, select the appropriate number of cells in the adjacent columns.
Step 6: Select the same button to get the wizard box back and click Finish button.
Step 7: That’s all.
If you have any query related to this article then feel free to ask in the comment section. We will be glad to help you.
Thank You & Stay Techie…