4 Ways to Split Cells in Microsoft Excel

In this video tutorial, I will show you how to split cells in Microsoft Excel using four different methods like Flash Fill, Text to Columns &, Formulas with Functions (LEFT, RIGHT, SEARCH, LEN), and Power Query. So when you need to split or divide cells in Microsoft Excel consider one of these methods.

My Microsoft Excel Playlists

0:00 Introduction
1:28 Using Flash Fill in excel to split cells
3:17 Text to Columns to divide cells in Excel
4:51 Building a formula with functions to split cells in Microsoft Excel
11:17 Using Power Query to split cells

[TimersHappyTimes]

Thank you very much for sharing your knowledge, very useful 👏🏼🙏

[gabybourdeaux]

Thank's for sharing the knowledge with us. The informations tought in the videos are clear and easy to understand.

[apoorvasgala]

Right formula I was looking for days 👍

[DemetriPanici]

Definitely going to utilize this at work today

[linfobytecursos]

Parabéns por ajudar tanta gente! sou do Brazil e grande fã do seu trabalho gostaria de abrir uma franquia em português com vocês! Sou professor de tecnologia também há 7 anos!

[rc]

Thanks very much for the info. I have learnt alot

[rbwd]

Is there a way to split columns so that all cells below the header are vertically split in half?

[aaronpauldayrit]

How to do split a one column into two part? Like if column b2 i want to make it 2 parts please help thank you

[LaIiwon]

where can i find ctr+z ctrl+y buttons?

[MoniMeka]

yeah that formula is somethin' else! LOL

[OvOneV]

This is NOT splitting cells, it's splitting DATA in the cell.