반응형
In this article, I'll show you the fastest and easiest way to parse a string into separate columns.
The best part is, this technique doesn't require any formulas.
The numbers and some barcode labels were combined into a single string.
[How To]
1. Select the range of data that you want to convert.
2. On the Data menu, click Text to Columns.
3. In Step 1 of the convert Text to Columns Wizard, click Delimited and then click Next.
4. In Step 2, select the Space check box and then clear the other check boxes in ther Delimiters section.
The Data preview window shows the number and barcodes in two separate lists.
5. In Step 3, click a column in the Data preview window. and then click Text under Column data format.
Repeat this step for each column in the Data preview window.
6. Click Finish. The converted data will be show.
With just a few mouse clicks, you can convert a cloumn of labels into columns of data.
반응형