How to Extract Numbers from Text in Excel | 3 Methods - Power Query, VBA Function & TEXTJOIN Formula

In this video I demonstrate three methods for separating text from numeric characters within a text string. The methods are:

2) VBA functions

3) TEXTJOIN formula. TEXTJOIN is only available in more recent versions of Excel.
------------------------

[madalinmd]

Amazing, it was the first time when I used column from examples. It's like you opened a new world for me.

[danielcatalao]

Brilliant formula. This is what I needed for Excel. In Google Sheets it is piece of cake but in Excel is "rocket science". Thanks!

[tinkerbrownie]

I didn't realize Power Query could be this incredible. Thank you!

[burakkaganylmazer]

Thank you for showing different solutions to same problem. Understanding how Power Query works solved my problem. much appreciated.

[PlantigradeWolf]

Thank you for this tutorial! saved me tons of unnecessary work <3

[KKLeung]

How can it deal with the content with decimal number? Thank you

[samuelworku]

You have no idea how much you made my life easy. Thank you!!

[elmique]

Dude, you saved me a ton of hours of work. This worked like a charm. Thanks!

[ano]

Very useful and detailed video. Thanks a lot!

[andrewsegawa]

Awesome sir!! I will use the formula. I have followed this channel and saved this video for future reference. Big thank you!!!!

[trabink]

GREAT VIDEO, GREAT SOLUTION the power query!, thank you!!

[Luciano_mp]

Brilliant man... Very good. Thank you!

[vinhvu]

Exactly what I needed, thank you, saved me a lot of time today!!

[titoart]

Very informative and simple to follow tutorial!!! Thanks a lot!!!😊

[albertusmostert]

Thank you for the explanation, you saved me a ton of time!!!!

[rooparaj]

This is what I exactly needed :)Thank you !!!!its just saved so much time for me

[mechid]

Very very nice explaining. Thank you so much :)

[ryanc]

power query is amazing for this - thank you!!!

[edricksackie]

Many thanks, the vba solution is very effective for the format of my data.

[IvanCortinas_ES]

Extremely well explained. Thank you for these magnificent content!!!