When you have some values to pull out of a text or numerical string in a cell, you can use the extract commands in Power Query to make it easy. This is an great option to use instead of using the RIGHT, MID or LEFT functions in Excel or trying to split the value by some delimiter. It's so much more easier to pull the data into the Power Query editor and using Transform and Extract to pull your desired text string out.
No comments:
Post a Comment