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.

[@RohitKumar-cc7zi]

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

[@MDataFinnovatics]

Thank you Rohit Kumar!

[@muhammadsaqlain5162]

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

[@MDataFinnovatics]

Thank you Saqlain!

[@lilyfullery4779]

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

[@MDataFinnovatics]

Thank you Lily!

[@muhammadsaqlain5162]

Sir, no difficult but amazing tricks.

[@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!

[@ajaymb4658]

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

[@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 - kzbin.info/www/bejne/qaG8qYGdhsyaY7s INDIRECT - kzbin.info/www/bejne/a4rIqZJ-j7ujeM0 OFFSET - kzbin.info/www/bejne/haKraml8fZV8oNE

[@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.

[@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

[@suyenshakya4320]

Is their any other formula without concat and textjoin formula

[@munnarajbhar8214]

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

[@Adityasshenoy-rw4ox]

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

[@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

[@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.

[@yashpatil3375]

Amazing trick sir ji 👍

[@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

[@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

[@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),""))

[@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.

[@farhanalvi5905]

Flash fill say hp jaye gaa

[@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!

[@maniruzzamanupsachib593]

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

[@cutoworld7425]

Sir kindly explain this formula

[@MDataFinnovatics]

Sure Cuto!!

[@ashmitpanchal7330]

Please explain 😊😊

[@amritaingole9753]

Thers no concat in my excel so its uswless for mw

[@MDataFinnovatics]

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

[@AnujKumar-bu4sc]

In my laptop this formula is not working

[@amritaingole9753]

Its not working for me..

[@kamaldeepsharma1518]

Please explain the same

[@MDataFinnovatics]

Okay Kamal Deep Sharma.

[@harshareddy7678]

Hi

[@MDataFinnovatics]

Hello Harsha

[@inamullahmnch]

Please 🙏

[@riddhishaw1481]

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

[@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

[@itskannuyt]

Not working

[@rameezrahamthulla8001]

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

[@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