Download the featured file here: [ Ссылка ]

In this Microsoft Excel video tutorial I explain four ways to split data into multiple columns. Data can be split into columns based on one or more delimiter. A delimiter might be a space, a comma, a semi-colon or a dash. Excel can split data on each occurrence of the same delimiter (for example each occurrence of a space) or it can split data based on each occurrence of any number of delimiters being used.

Table of Contents
00:00 Introduction
00:26 Split data with Text to Columns (single delimiter)
02:19 Split data with Text to Columns (multiple delimiters)
04:40 Split data using Flash Fill shortcut key
05:39 Split data using the TEXTSPLIT function (single delimiter)
06:36 Split data using the TEXTSPLIT function (multiple delimiters)
07:59 Split text using Power Query (single delimiter)
09:36 Split text using Power Query (multiple delimiters)
12:17 Automate splitting text with an Office Script



#excel365 #excel #exceltutorial #exceltips #exceltricks #microsoftexcel #powerquery

свернуть