Category Archives: microsoft power query

How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata

Posted on by

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.
The post How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata appeared first on TechRepublic.
Continue reading How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata→

How to Extract Delimited Data Using Excel Power Query

Posted on by

Learn how to use Excel Power Query’s extract and split column features to extract delimited strings into their components with this step-by-step tutorial. Continue reading How to Extract Delimited Data Using Excel Power Query→