Extracting characters or components from a value requires specialized functions in Microsoft Excel, but Power Query doesn’t. Try Power Query the next time you have to puzzle through a data extraction requirement.
The post How to quickly extract delimited data using Microsoft Excel Power Query appeared first on TechRepublic.