Split Text based on multiple characters in Excel | Excel Power Query to split the text

#excel #powerquery #
Split Text based on multiple characters in Excel | Excel Power Query to split the text

In this video let us see how to split the text based on multiple characters in Excel through power query

Most of the time while working with data, we may have the scenario to split the text based on multiple characters. The basic "Text to columns" enable the options to split the text with a pre-defined delimiter or a custom delimiter with a single character but won't support the split with multiple characters.

Power Query for Excel is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources, and a Power Query Editor for applying transformations. Power Query for Excel supports hundreds of data sources with built-in connectors.

Power Query can be used to split the data based on multiple characters in Excel.