How to split columns in Excel
Sometimes you need to split a column when using Excel to statistic data. The problem is that splitting the column with a blank data column is quite simple, you just need to insert the column. But if you want to split the column already available data, need to follow the following instructions of TipsMake.com.
To be able to split a column in Excel, you need to explicitly identify that data column. Note that Excel will not know which column to split to get data, so you need to give it a splitting sign like a special symbol that is different from other words.
As in the example below, i will use dashes to separate the text behind the code to the next column.
How to split columns in Excel Picture 1
First, highlight the column that you want to split.
Next you open the Data ribbon on the toolbar, next you click on Text to Columns of the Data Tools section of this ribbon.
The Convert Text to Columns Wizard function window appears.
You can choose from two types of column splitting:
- Split the column according to the data contained in the column: Delimited (the selection should follow our example in this article).
- Split columns by column width : Fixed width .
Click Next to continue.
How to split columns in Excel Picture 2
Next, you choose one of three options for Excel to base on the column data:
- Tab : Separate columns based on tab marks.
- Semicolon : Separate columns based on semicolons.
- Comma : Separate columns based on commas.
- Space : Divide columns based on spaces or spaces.
- Other : Divide columns based on the content of the next blank characters.
Click Next to continue.
How to split columns in Excel Picture 3
In this step, you will see how the column will split in the Data preview .
You click Finish to complete the separation.
How to split columns in Excel Picture 4
The result you get is that the data column has been split into two columns as the original goal.
How to split columns in Excel Picture 5
You should read it
- How to split first and last names into 2 columns in Excel
- Quickly split data with Text to Columns in Excel
- How to convert columns into rows and rows into columns in Excel
- How to fix columns in Excel
- MS Excel - Lesson 4: Working with lines, columns, sheets
- Format Excel 2007 spreadsheet
- How to combine 2 columns Full name in Excel does not lose content
- How to split columns in Word and tips or handle columns in Word
- How to delete, add columns in Excel
- How to keep Excel and Excel columns fixed?
- How to fix columns and headlines in Excel
- Split data in columns in Excel
Maybe you are interested
Instructions for quickly aligning Excel printed pages, printing to fit the paper, without losing columns
Excel - Convert columns to rows in Excel
How to delete rows and columns in Excel with mouse or key
Instructions on how to break columns in Word simply and quickly
Column order in Excel is reversed, why and how to handle it?
Excel does not allow inserting additional columns and rows [FIXED]