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, clic..