Trick 004 Split columns or paragraphs with power query

Microsoft Excel offers a set of functions for working with text. When you want to extract part of a text string or split a string into rows or columns, there are three particular functions that get the job done. Also in excel, the split is also done on Power query. With the power of Power Query, this division is even easier and more powerful.

    Splitting a column or paragraph from a Power Query seems simple, but sometimes we also encounter special cases. They are not prescriptive. With this example are 2 of the many special cases that you may encounter when doing Power Query