How to extract numbers from text in excel | Extract number formula excel | Extract number from cell

[@MDataFinnovatics]

Call us at [phone] for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍

[@CommerceCoachingRanchi]

really very help full can you please tell me how to replace number from all statement via formula if any
thanks in advance

[@bhuwanc8]

Very helpful.

[@munnarajbhar8214]

Sir bank statement me number aur bhi aate hai toh usko kaise split kare

[@muhammadsaqlain5162]

You are birilliant Teacher very very nice tricks awesome tricks 💯 👍.

[@MDataFinnovatics]

Thank you Saqlain!

[@RohitKumar-cc7zi]

ThIs one is so good, Thanks a lot just keep it up

[@MDataFinnovatics]

Thank you Rohit Kumar!

[@ajaymb4658]

Very helpful, but what if there is no "cancat" option in excel in that scenario is there any replacement for same?

[@suyenshakya4320]

Is their any other formula without concat and textjoin formula

[@lilyfullery4779]

Thank your for your video , appreciate your efforts
please explain the formula

[@MDataFinnovatics]

Thank you Lily!

[@kadarmumbaikar]

I don't have words it's amazing 7 formula at the time ..wow ..sir if agar target complete nahi hota hai to bhi aap explain kar dena sir....
One request sir if possible hai to sir
Aap start kardo do yaha Excel Basic se lekar Advance, Dashboard, Macros,VBA ... series sir ...lots of love sir

[@MDataFinnovatics]

Thanks, Kadar for your words. It really gives us the motivation to make more videos. Yeah, we are trying our level best to give from basic to advance level of knowledge in Excel and then we will move to Dashboards, VBA, and Power BI. Don't forget to share and subscribe to the channel!

[@muhammadsaqlain5162]

Sir, no difficult but amazing tricks.

[@rajadey1552]

It's superb sir
Sir hope you reply
If the number is formatted in text format. Will this formula still work?

[@MDataFinnovatics]

Thanks Raja, yes sir the formula still works.

[@kannanmassey5783]

Superb....kindly upload vedios for vlookup, indirect, offset with realistic type company data to apply. Thanx n regards

[@MDataFinnovatics]

Kannan, We have already posted videos on Vlookup, Indirect, OFFSET, and other formulas.
Please check the below links.
VLOOKUP - th-cam.com/video/spYxNgQgg-Y/w-d-xo.html
INDIRECT - th-cam.com/video/5Yex_HZVpBk/w-d-xo.html
OFFSET - th-cam.com/video/OqH96FH0Ijo/w-d-xo.html

[@mangrooram7529]

I am using Excel 2019 this is showing only one character. There is any problem in Excel 2019.

[@MDataFinnovatics]

Mangroo, there is no problem in Excel 2019. Please validate that none of the steps are missing.

[@maniruzzamanupsachib593]

remove unwanted characters does not work in my computer. please solution.

[@aaizu6473]

To extract the numeric character use below formula
CONCAT(IF(ISERROR(MID(F2,ROW(INDIRECT("1:"&LEN(F2))),1)*1)=FALSE,MID(F2,ROW(INDIRECT("1:"&LEN(F2))),1),""))

[@farhanalvi5905]

Flash fill say hp jaye gaa

[@yashpatil3375]

Amazing trick sir ji 👍

[@kannanmassey5783]

Sir I am using her 2016 so how to concatenate the exctracted text in a cell. Concatenate is not working on returned array. Kindly help

[@MDataFinnovatics]

Kannan, please elaborate your question!

[@kannanmassey5783]

@@MDataFinnovatics Gm, Sir to join text in excel version 2016
Textjoin Or concat functions are not available.

[@MDataFinnovatics]

@Kannan, Textjoin and Concat functions are available only in the 2019 version or later. They aren't available in Excel 2016 or earlier.

[@kannanmassey5783]

Sir is there any way to fetch characters contained
in an array eg. {"4";"0";"a";"7";"r";"6";"t";"9";"i"}
one by one and combine only alphas in another cell

[@MDataFinnovatics]

Yes, you can also extract the characters only. Same things is explained in the video if you notice!

[@Adityasshenoy-rw4ox]

Hi sir.. i need detailed explanation on formula based extracting text from numbers

[@prabhakarrajendren9664]

Sir how to split the number and text like this
304 - Ganesh street

[@MDataFinnovatics]

The easiest way is using the text to columns option and use "-" as others delimiter.

[@amritaingole9753]

Thers no concat in my excel so its uswless for mw

[@MDataFinnovatics]

Hello Amrita ji, you can try the other ways also.

[@PramodHande]

i want 1 formula, that can i auto fill vendor name as per type there product name

[@MDataFinnovatics]

Please explain your query in detail with example.

[@pramodhande7924]

@@MDataFinnovatics I have my data. That i required when I type product name after that next column auto fill with this product vendor name

[@lilyfullery4779]

CONCAT(IF(ISERROR(MID(A1,SEQUENCE(LEN(A1)),1)*1),MID(A1,SEQUENCE(LEN(A1)),1),""))
this formula helped me , and its bit easier - hope it will help someone

[@MDataFinnovatics]

It sounds fantastic! You've created an excellent formula that could work flawlessly! However, I did not apply this calculation because the SEQUENCE formula is not available in all versions of excel!

[@krishnamamidala3160]

​@@MDataFinnovatics Right sir

[@SaurabhSharma-ry8iz]

Sir great video
Maine sir substitute function 26 times kiya output aa gaya
Kya ye sahi h

[@MDataFinnovatics]

Saurabh, aap substitute function bhi use kar sakte ho bahut wo bahut lengthy formula ban jayega (26 times substitute function).

[@SaurabhSharma-ry8iz]

@@MDataFinnovatics ok sir thanks

[@AnujKumar-bu4sc]

In my laptop this formula is not working

[@santoshtodkar4463]

Sirji pls explain this formula...
Thank you in advance

[@MDataFinnovatics]

Sure Santosh Todkar!!!

[@santoshtodkar4463]

@@MDataFinnovatics Sirji excel ke formula na nasha se hai sirji apka formula bar bar practice kiya hai
CONCAT(IF(ISNUMBER(MID(B23,ROW(INDIRECT("1:"&LEN(B23))),1)*1)=FALSE,MID(B23,ROW(INDIRECT("1:"&LEN(B23))),1),""))
but we want more sirji how to use formula and when to use it..

[@MDataFinnovatics]

I like this craziness. Don't worry, I will create a video explaining the above formula!

[@santoshtodkar4463]

@@MDataFinnovatics Thank you sirji

[@amritaingole9753]

Its not working for me..

[@cutoworld7425]

Sir kindly explain this formula

[@MDataFinnovatics]

Sure Cuto!!

[@ashmitpanchal7330]

Please explain 😊😊

[@harshareddy7678]

Hi

[@MDataFinnovatics]

Hello Harsha

[@itskannuyt]

Not working

[@kamaldeepsharma1518]

Please explain the same

[@MDataFinnovatics]

Okay Kamal Deep Sharma.

[@inamullahmnch]

Please 🙏

[@anilkumarparmar1784]

Formula samjna hi hai

[@MDataFinnovatics]

Okay Anilkumar, we will create a video on that very soon!

[@anilkumarparmar1784]

@@MDataFinnovatics thank you very much, all very interesting excel formula videos

[@rameezrahamthulla8001]

It will not work with special characters like @#&%etc

[@riddhishaw1481]

अगर इसे easy process में बताए तो कमजोर छात्रों को मदद मिलेंगी

[@Abhi-oi1cd]

Are yar ye formula kaam nahi kiya

[@vijaypol1835]

Please explain this formula sir

[@MDataFinnovatics]

Sure Vijay. Lets get few more comments. Don't forget to share the video with your friends!!

[@madhurasuri5244]

It's not working