Quickly Split Data with Text to Columns in Excel

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

Step 1: Select the data area to be processed, and then click Tab Data ? Text to Columns, the following dialog box appears:

Step 2: Select Dellimited and then click Next

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.

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.

If the operation is correct, we will get the results as shown below: Split the numeric and USD data into 2 columns