Using the Text to Columns Tool . One way to split data into multiple columns in Microsoft Excel is to use the built-in Text ...

Step 1: Go ahead and open the Excel spreadsheet you want to use. In our example, we have a simple table of products, services, projected prices, and their actual prices.