Hi all,
I want to split the word, say "ExcelPowerQuery" at each occurrence of capital letter, as "Excel", "Power" and "Query" in separate columns.
But I have Excel 2013 power query , where I dont found option "By Lower Case to Upper Case", under split column section.
So how I can do this by using User Interface of M function.
Thanks
I want to split the word, say "ExcelPowerQuery" at each occurrence of capital letter, as "Excel", "Power" and "Query" in separate columns.
But I have Excel 2013 power query , where I dont found option "By Lower Case to Upper Case", under split column section.
So how I can do this by using User Interface of M function.
Thanks