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.

Practice Sheet:

My Microsoft Excel Playlists
Beginner Microsoft Excel Tutorials:
How to use functions and formulas in Excel:

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

Source: zero24-7.org

See also  Come decidere più velocemente?

10 comments on 4 Ways to Split Cells in Microsoft Excel

  1. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *