Power Query to Extract Number and Text from Alphanumeric Data

How to extract Text and Number from AlphaNumeric data using Power Query in Excel is explained in this video.

🚚Check my store on Amazon.

Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

#PowerQueryTrick #ExcelPowerQuery #ExtractNumber

[josesierra]

Simply amazing, thanks for the lesson!

[dcipher]

Had no idea! Crazy stuff. Saved me today! Thanks for sharing!!

[onurcegilli]

Thank you! That is exactly what I was looking for

[morrisonka]

Excellent, Sir !!
I will continue to learn with you !!😚😚😚

[enricomendiola]

Great Video! How can I use the text.remove function using a column that contains some characters instead of using this "a".."z"

[andrearestori]

Great video, you're amazing. I have one question: how can I change the format of the numeric cells from text to number? I ask this because if every cells remain as shown in the video they will be considered by excel as text and it will be impossible to use them to compute formulas or whatever. Thank you from Italy for your time Ajay!

[santoshkahar]

Very nice. If we have huge data then how we can extract those..it would be great if you share with large data.

[yyusof]

marvelous lesson!

I've a question, How do I extract the number "22" from "LTM-22-6755" and change the "22" to "2022".
"LTM-22-6755" --> "22" --> "2022"

[mistazed]

Is there anway I can sepreate 2 values from text and keep them separate. I.E the debt is £123.45 and payment was £90.96. To give me the result £123.45 in one cell and £90.96 in a second cell

[badmintonlife]

Good video!
How do I remove dash hyphen left or right of a letter, but not between numbers?
00-CM-00-12
00-C-M00-12
00CM-00-12
After transformation
00CM00-12
Thanks