In this video, I demonstrate how to split cells in Excel, such as first and last names, that are combined in one column, into their own respective columns.

** LINKS **
► LEARN POWER QUERY FOR 80% OFF THIS BLACK FRIDAY: https://www.excelcampus.com/power-query-pro-course-offer/
► Download the workbook: https://www.excelcampus.com/powerquery/split-column-power-query

**********
EXCEL-FRIENDLY ACCESSORIES WE USE: LOGITECH KEYBOARD
Check out all the tech we use and recommend at https://www.excelcampus.com/store
**********

- Split Cells: Automate with Power Query
We can spit into multiple columns when there are more than two words, names, or strings in a single column.

~ Related Videos:
Power Query Overview - Automate Data Tasks in Excel & Power BI: https://www.youtube.com/watch?v=vq9AgAtSvQg
15 Shortcuts for Power Query in Excel or Power BI: https://www.youtube.com/watch?v=GJQY_28sWHI

Split Data into Rows with Power Query: https://www.youtube.com/watch?v=tdblfzJ2mEY

#MsExcel #ExcelCampus
00:00 Introduction
04:15 Split Columns
07:09 Fully Automate