In Excel, select the cell, group of cells, or entire column that has the text you want to split. It'll need to contain two pieces of data separated by a "delimiter." ...

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

5 Ways to Instantly Split Cells into Columns & Rows in Excel Watch this video on YouTube. Browse through more resources below from our in-depth content covering more areas on Microsoft Excel.

Learn how to use the Text to Columns options to split comma seperated text in Microsoft Excel. You can do the same in Google Sheets as well.

There are many different tips and tricks when using Excel. In this article, we're going to show you how to delete all the text up to a certain character when importing data to your Excel document.