Go to Data > Data Tools > Text to Columns. Select the delimiter or delimiters to define the places where you want to split the cell content, and then select Apply.

Jul 3, 2024 · 5 quick and easy ways to split cells in multiple parts in Excel. Download our practice workbook, modify data, find new outputs and exercise!

Apr 22, 2024 · Splitting a cell in Excel might seem like a difficult task, but it’s actually quite simple once you know the steps. By splitting a cell, you can divide one cell into multiple cells either horizontally or …

To split a cell in Excel, add a new column, change the column widths and merge cells. To split the contents of a cell into multiple cells, use the Text to Columns wizard, flash fill or formulas. Use the …

Learn how to split cells in Excel (split a cell into multiple columns) using Text to Column, text functions or Flash Fill

Aug 29, 2024 · In this tutorial, I will show you how to do so by using the Text to Column feature of Excel alongside some other handy methods (the Flash Fill feature of Excel, and a combination of Excel …

Aug 19, 2025 · Steps to split a cell into two rows in Excel: Suppose cell A2 contains “ John Smith, Maria Clara ”. If you only need to split one or two cells occasionally, the manual method is your easiest …

Jun 29, 2025 · How to Split Data in Excel (2025): Learn how to split one cell into multiple cells in Excel using 6 proven methods: Flash Fill, Text to Columns, TEXTSPLIT, Power Query & more. Works in …

Dec 17, 2024 · Whatever the case, clean, organized data is essential, and Excel has a few powerful techniques to Split Data into separate cells effectively. This guide covers four methods: Text to …

Aug 12, 2025 · In this article, we will learn all the smart ways to split the cells in Excel using delimiters, fixed width, Flash Fill, formulas, and Power Query. Table of Contents: What Is Cell Splitting in Excel?