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

You can take the text in one column and split it into multiple columns using the Convert Text to Columns Wizard. To get started, open the Excel Sheet in which you would like to split a single ...

In this article, I’ll use two IF() functions to split a simple “database” sheet into multiple columns, based on a value in another column. Disclosure: TechRepublic may earn a commission from ...