Quickly split data with Text to Columns in Excel
Office work and accounting always have to work on excel everyday. And there are many types of data that need to be filtered, separated, and possibly complicated functions. Fortunately, Excel has integrated Text to Columns feature with extremely fast data separation task. What is that? Let's find out through the following article:
![Quickly split data with Text to Columns in Excel Picture 1](https://tipsmake.com/data/images/quickly-split-data-with-text-to-columns-in-excel-picture-1-qYb7fV5FY.png)
1. What is the Text to Columns used for?
Text to Columns feature is a good application of Excel hidden in the Data tab specializing in separating data into specific columns specified.
2. Examples of how to use Text to Columns
In the example illustrated below, we need to separate the data in the same column into separate column, USD column separately
Quickly split data with Text to Columns in Excel Picture 2
Step 1: Select the data area to be processed, and then click Tab Data → Text to Columns, the following dialog box appears:
Quickly split data with Text to Columns in Excel Picture 3
Step 2: Select Dellimited and then click Next
Quickly split data with Text to Columns in Excel Picture 4
Step 3: The dialog box Convert Text to Columns Wizard - Step 2 of 3 appears, select the characters that separate the data types in the selected cells.
For example, the cells selected above are separated by spaces, so you select Space.
Quickly split data with Text to Columns in Excel Picture 5
If the separator character is a different character, select the options similar to that character:
Tab: separated by tab keys.
Semicolon: separated by semicolons.
Comma: separated by commas.
Space: separated by spaces.
Other: other characters, if you choose this option you need to enter another character in the box next to it.
After choosing, click Finish to continue.
Quickly split data with Text to Columns in Excel Picture 6
If the operation is correct, we will get the results as shown below: Split the numeric and USD data into 2 columns
Quickly split data with Text to Columns in Excel Picture 7
You should read it
- How to split columns in Excel
- How to split text into multiple columns in Word
- How to split first and last names into 2 columns in Excel
- Word 2016 Complete Guide (Part 13): Divide the text column
- Format column text in Word
- Tips for handling columns in Microsoft Word
- Split data in columns in Excel
- How to split columns in Word - Instructions on dividing columns in Word 2007, 2010, 2013, 2016
- Format Excel 2007 spreadsheet
- How to split columns in Word and tips or handle columns in Word
- How to break pages, split sections in Word 2016
- Instructions for fixing split text errors - dropped lines in Word