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

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