Print

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:

Extract in Power Query (LEN, LEFT, RIGHT in excel) - #6 (M)agic (M)ondays
Was this helpful?

Reader Interactions

Comments

  1. Hi, I came found a lot of blogs that were really helpful for understanding and learning. I also thought that knowing this information would encourage me to study more and provide opportunities. This is incredibly creative and inventive; you are an inspiration. It’s clear that you take pride in your job.

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents