Download Excel File: https://ift.tt/2Nw3F8M
Learn how to split text by Capital Letter. See the huge array formula in an Excel Worksheet and then the simple Power Query M Code formula to accomplish this task. Learn about the Power Query M Code Functions: Table.AddColumn, List.Count, Splitter.SplitTextByCharacterTransition, List.Max, Table.SplitColumn.
Downloadable Excel File has Excel Worksheet Array Formula that works in Office 365.