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: [ Ссылка ]
► Download the workbook: [ Ссылка ]
**********
EXCEL-FRIENDLY ACCESSORIES WE USE: LOGITECH KEYBOARD
Check out all the tech we use and recommend at [ Ссылка ]
**********
- 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: [ Ссылка ]
15 Shortcuts for Power Query in Excel or Power BI: [ Ссылка ]
Split Data into Rows with Power Query: [ Ссылка ]
#MsExcel #ExcelCampus
00:00 Introduction
04:15 Split Columns
07:09 Fully Automate
How to Split Cells & Text in Excel with Power Query
Теги
excelexcel campusexcel power queryexcel split functionhow do you split a cell in excelhow to divide one cell into two in excelhow to separate columns in excelhow to separate first and last name in excelhow to separate words in excelhow to split cellshow to split cells in excelhow to split one column into multiple columns in excelpower querysplit line break using text to columns
