Forum Discussion

SArtaz's avatar
SArtaz
New Member
2 years ago
Solved

extract text in column

Hello. I have a coulmn that has 4 and 5 characters in various rows. I want to extract data into a new column; I want the 3rd and 4th characters from the left. In this example, it would be "45"...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SArtaz ,

    Please try this way:
    In Power Query, click "Custom Column":

    Use this M code:

    Text.Middle([Column1], 2, 2)

    And the final output is below:


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SArtaz ,

Please try this way:
In Power Query, click "Custom Column":

Use this M code:

Text.Middle([Column1], 2, 2)

And the final output is below:


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.