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

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

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

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

Very useful and detailed video. Thanks a lot!

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

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

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

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

Decimal Numbers are Not Considered here ? I tried with Adding End If before Next i and Last Line Changed as ExtraxtNumbers = Val(NumericChars) Found working Well. Thanks for Sharing

Fantabulous. Essayist explained. Don't know the power query will resolve this problem. Felt that you are in front of me. Learn new thing from you. Thanks & Regards Alok Ghosh

that's very great

Thanks for your help, I have a question for you, if I would like to extract the numbers, but divided by a space or comma, eg: Text 12 Text 1994 Text Text 100.000 = 12,1994,100.000 or 12 1994 100.000. How can I do? (With VBA code) Thanks

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

such a great video

why when i typed the extractnumbers the function is not available??

This doesn't help if you have a cell that says "2023 - Q1" or "1/1/2023" that is displayed as "Jan - 2023". 😓

loved it

I need to input a vin# for a vehicle and I need it to tell me the year (from a table of values). the 10th digit in a vin# is the year of that vehicle.

How would you separate address field into numbers and text when the street number contains "-"; for example, "10-123 Gilbert Street" into "10-123" and "Gilbert Street"?

Attempted to use the formula... Worked to fix one problem with getting my alphabetical values from string but gave me an additional issue with blank cells returning a reference error "#REF!".

Can you share the formulae of Excel query

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

Very good We can also use sequence() function instead of row(INDIRECT (.. Like: sequence(len(A2),1,1,1)

Very very nice explaining. Thank you so much :)

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

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

Thank you very much for creating this video. I would have one question on " How do I extract different numbers from a long text string using VBA? For example "21045; i. to provide access control hardware. 22356; ii. existing infrastructure and system" etc.. In this case, I would like to extract 21045 and 22356 returning as "21045 , 22356" with a comma as a delimiter.

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

Brilliant man... Very good. Thank you!

Pure witchcraft. Thank you for the video. Very helpful.

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

Brilliantly explained too. Thank you

Thanks a lot. Very helpful formula

Thank you Sir, I found what I needed here, you've been so helpful. Congratulations on your channel. 👍👍

Thank you so much it's too easy

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

awesome. just awesome. many thanks Chester!

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

Thank you so much!

Exactly what I needed thank you so much

Genius - thank you!

आपका शिक्षण अच्छा है ❤

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

Awesome awesome Sir 💖💖💖

thanks!