How to Split a Cell in Excel into 2 Rows

If you are trying to clean data in Excel, there are a couple of tricks that can help you do the work faster and easier. In today’s video, we show you how to Split Cells in Excel. This method is useful if you want to split text into separate cells such as a column with names into first names and last names, for example. This quick tutorial ...

480K viewsJan 6, 2022

Excel Tutorial

5:43:05

The Ultimate Excel Tutorial - Beginner to Advanced - 5 Hours!

YouTubeSimon Sez IT

1.9M viewsDec 6, 2021

32:49

Microsoft Excel Tutorial - Beginners Level 1

YouTubeTeacher's Tech

13.4M viewsMar 19, 2018

11:55:34

Excel Tutorial Beginner to Advanced - 12-Hour Excel Course

YouTubeSimon Sez IT

1.2M viewsJan 25, 2023

Top videos

14:03

4 Ways to Split Cells in Microsoft Excel

YouTubeTeacher's Tech

165.6K viewsNov 22, 2021

5:01

How to Split Cells in Excel | Split Cells or Split Data

YouTubeChester Tugwell

9.6K views7 months ago

7:36

How to Split Cells in Excel

YouTubeRath Point

59K viewsSep 10, 2021

Excel Tips and Tricks

2:07:11

30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial

YouTubeSimon Sez IT

99.4K viewsJan 9, 2024

25:38

Top 20 Microsoft Excel Tips & Tricks

YouTubeKevin Stratvert

868K viewsOct 23, 2020

1:18:54

Top 15 Excel Tips and Tricks of 2025 to Save Time and Speed Up Your Work

YouTubeSimon Sez IT

9.7K views11 months ago

14:03

Find in video from 0:00Introduction to Splitting Cells

4 Ways to Split Cells in Microsoft Excel

165.6K viewsNov 22, 2021

YouTubeTeacher's Tech

5:01

How to Split Cells in Excel | Split Cells or Split Data

9.6K views7 months ago

YouTubeChester Tugwell

7:36

Find in video from 04:53Splitting Cells by Using Excel Formulas

How to Split Cells in Excel

59K viewsSep 10, 2021

YouTubeRath Point

How to split multiple lines into separate cells in excel

7:32

Find in video from 00:28Text Join and Text Split Formula

How to split multiple lines into separate cells in excel

76.6K viewsJan 25, 2023

YouTubeKarina Adcock

How to Split Cells in Excel (4 Easy Methods)

7:13

Find in video from 0:00Introduction to Splitting Cells

How to Split Cells in Excel (4 Easy Methods)

11.4K viewsSep 15, 2021

YouTubeSpreadsheeto

11:17

How to Split One Cell into Two in Excel

4.7K viewsJun 9, 2023

YouTubeExcelDemy

How to split a cell into two rows in Excel

2:14

Find in video from 02:06Converting the Text into Rows

How to split a cell into two rows in Excel

2.6K viewsApr 9, 2024

YouTubeSpreadCheaters

4:28

Find in video from 0:00Introduction to Splitting Cells

3 Ways to Split Cells in Excel (Using Data Tools, Functions, and Shortcuts)

7.6K viewsSep 20, 2023

YouTubeExcel Dictionary

2:35

How To Split Excel Cells Into Columns

56.3K viewsMar 23, 2021

YouTubeInsider Tech

1:16

Find in video from 00:02Introduction of How to Split Cells in Excel [2024] Easy Tutorial

How to Split Cells in Excel (Easy Tutorial)

195 viewsJul 17, 2024

YouTubeTHE APP EXPERTS

12:38

Excel Challenge: split a cell into multiple rows

630 views5 months ago

YouTubeExcelMoments

0:20

Master Excel: Split Data from One Cell into Two Cells in 1 Seconds!

213 views8 months ago

YouTubeLearn With Bilal Saeed

1:00

Split data into different columns in Microsoft Excel

2.3M viewsOct 9, 2019

YouTubeMicrosoft 365

2:01

Find in video from 00:27Splitting Cell Diagonally Down

How To Split One Cell Into Two Parts In Excel?

117.5K viewsJun 22, 2022

YouTubedptutorials

0:50

Find in video from 00:18Splitting Cells by Spaces

How to Split a Cell in Excel 2016

662.5K viewsFeb 24, 2017

YouTubeExcel, Word and PowerPoint Tutorials from How…

5:28

Find in video from 04:37Comparing the Two Methods

Separate a Cell Into Two Parts in Excel (Two Headers, Same Cell)

62.4K viewsApr 10, 2024

YouTubeSpreadsheeto

1:15

How to split cells containing text in Excel

120.1K viewsJul 25, 2017

YouTubeFigureAssist

1:08

How To Split Your Data into different Columns in SECONDS with this Simpl…

20.9K views8 months ago

YouTubeSharePoint Dougie

1:38

Find in video from 00:26Open Excel File and Select Column

How to Split One Column into Multiple Columns in Excel | How to Use Text t…

245.8K viewsJun 25, 2022

YouTubeExcel, Word and PowerPoint Tutorials from How…

1:09

Split Text Into Multiple Columns in Excel | Best Method for Big Data

1 views2 weeks ago

YouTubeSuccess Blueprint

3:15

Find in video from 03:00Finalizing the Split

How to Split Multiple Lines in a Cell into a Separate Cells/Columns

258.9K viewsOct 11, 2017

YouTubeTrumpExcel

4:15

Find in video from 00:49Merging Merged Cells

How to Split Merged Cells in Excel

21K viewsMar 12, 2021

YouTubeAgriMetSoft Team

3:16

Find in video from 0:00How to split a cell in Excel with two colors?

How to split a cell in Excel with two colors

84K viewsOct 4, 2021

YouTubeRath Point

14:46

Find in video from 09:53Standard Excel Formulas

How to split cells in Excel | 4 ways to make your data usable | Excel Off Th…

344.5K viewsMar 26, 2021

YouTubeExcel Off The Grid

1:40

Find in video from 00:10Writing Day Split

How To Split One Cell Into Two Parts In Excel?

58.3K viewsOct 5, 2023

YouTubeEnglish with History

11:54

5 Ways to Make Your Excel Data Usable (Splitting Cells)

41.9K views11 months ago

YouTubeMyOnlineTrainingHub

3:23

Find in video from 00:30Splitting Cells in Rows

How To Split Cell Values Vertically In Excel

16.9K viewsSep 9, 2019

YouTubeExcel 10 tutorial

1:52

How to split one single row to multiple rows in Excel

92.3K viewsJan 7, 2022

YouTubeExtendOffice

1:46

How To Split Cells In Excel | Divide Text into Two Columns In Excel

423 views5 months ago

YouTubeGlobalTechFix

See more videos

Top suggestions for How to Split a Cell in Excel into 2 Rows