Welcome to our Knowledge Base
Tip: Start typing in the input box for immediate search results.
Extract in Power Query (LEN, LEFT, RIGHT in Excel)
In today’s video we will go through the equivalents of LEN, LEFT; RIGHT in Power Query. You can create very complex transformations using the interface in Power Query.
Table of contents:
02:46 -Text Before delimiter
03:37 – Count length of text
04:03 – Extract First character
04:11 – Extract Last Character
04:16 – Extract Between Characters
04:46 – Extract from Range
Watch the tutorial:
Was this helpful?
Let us know your thoughts...