Separate Numbers from Text in Excel and Power Query

Learn how to separate number from text or vice-versa. In this video I am going to share with you 3 things
1. How to Separate numbers from text when the number is at the start of the text
2. How to Separate numbers from text when the number is at the end of the text
3. How to Separate numbers from text when the number is anywhere in the middle of the text (and can also appear multiple times)

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[dandysixties]

Text.Select([col], {"0".."9"}) with just this formula you can extract numbers

[raimundojs]

Great video. Thanks for sharing. Just corroborating some comments already made:
let
Source = Excel.CurrentWorkbook(){[Name="TabMixedText"]}[Content],
NewColJustText = Table.AddColumn(Source, "Text", each Text.Select([MixedText], {"a".."z", "A".."Z"}), type text),
NewColJustNumbers = Table.AddColumn(NewColJustText, "Number", each Number.From(Text.Select([MixedText], {"0".."9"})), type number)
in
NewColJustNumbers

[hrushikeshumalkar]

Amazing tricks sir, But can't we do it by flashfill function?

[olaayorinde]

Nice Video i think there is a much simpler way of solving question 3 without break a sweat by using Text.Select in power query. Good Job!!!

[JohnSatya]

Column from examples option in power query

[varunvk]

I am stuck at last power query part please explain step by step!!

[lavdeepsharma]

In my excel power query, only two option showing "By delimiter", "By Number of Character". Please help me out why other option not showing under spilt column .i am using Microsoft office professional plus 2016.

[SamehRSameh]

Please explain with working
Not show already done steps

[falgunpatel]

How to extract
From : 101E pinnacle park floor5
To: 101 E pinnacle park floor 5

[Fafalina]

Could you explain slower and the steps in between ? You lost me at split "split by one characters", thanks.

[aryansena]

Please go slow and show every step. Everyone is not pro. Thanks