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", However my Excel version does not have the Extract option within the Text Column area.
How do I accomplish pulling these characters (like I would if I had the Extract option) in the version I have?
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.
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.
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
