Split Data into Multiple Columns In Excel Based on Single or Multiple Delimiters | 4 Methods
Download the featured file here: https://www.bluepecantraining.com/wp-...
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
Watch video Split Data into Multiple Columns In Excel Based on Single or Multiple Delimiters | 4 Methods online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 22 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,665 once and liked it 46 people.