Скачать или смотреть Power Query Basic 09 - Split Column

In regular Excel, Text to Columns is the non-formula approach to split contents from a column into multiple columns. It is a very powerful feature in Excel which many users are not yet aware of it.

In Power Query, the Split Column is even more powerful, yet handy! In this video, I will show you the seven options available to us to split column in Power Query.

Introduction 00:09
By Delimiter 00:39
By Number of Characters 05:27
By Positions 07:43
By Lowercase to Uppercase 10:08
By Uppercase to Lowercase 10:47
By Digit to Non-digit 11:28
By Non-digit to Digit 13:31

You may download a sample workbook in my blogpost to follow along:
https://wmfexcel.com/?p=20059

If you like this video, please give a thumb up, share, comment, and subscribe my channel. 😁

#excel
#powerquery
#splitcolumn