Excel How To: Split Columns 3 Easy Ways

Опубликовано: 12 Октябрь 2022
на канале: Excel University
1,166
41

Learn Excel the FAST way, find out how here 👉 https://www.excel-university.com/yt

In this video, you'll learn three easy ways to split columns in Excel. This is a great technique to have in your toolkit when you're working with data, whether you're preparing it for analysis or presentation.

Each method is demonstrated step-by-step, so by the end of this video, you'll be able to confidently split columns in Excel like a pro!

Check out 7 Excel Time Hacks Everyone Should Know here    • 7 Excel Time Hacks Everyone Should Kn...  

Subscribe here 👉    / exceluniver.  . and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!

Watch VLOOKUP Hacks Playlist here https://www.youtube.com/playlist?list...

Watch VLOOKUP vs SUMIFS Playlist here https://www.youtube.com/playlist?list...

Watch Dynamic Arrays playlist here https://www.youtube.com/playlist?list...

Watch Treasure Maps playlist here https://www.youtube.com/playlist?list...

Watch Slow to Fast playlist here https://www.youtube.com/playlist?list...

Table of Contents:

00:00 - Introduction
00:05 - Objective
00:43 - Text to Columns
02:08 - SPLITTEXT
03:08 - Power Query