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
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!
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
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!
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
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),""))
@@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..
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
Call us at +91-9354674901 for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍
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
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!
Hi sir.. i need detailed explanation on formula based extracting text from numbers
Sir, no difficult but amazing tricks.
You are birilliant Teacher very very nice tricks awesome tricks 💯 👍.
Thank you Saqlain!
Thank your for your video , appreciate your efforts
please explain the formula
Thank you Lily!
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
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!
@@MDataFinnovatics Right sir
Superb....kindly upload vedios for vlookup, indirect, offset with realistic type company data to apply. Thanx n regards
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
ThIs one is so good, Thanks a lot just keep it up
Thank you Rohit Kumar!
It's superb sir
Sir hope you reply
If the number is formatted in text format. Will this formula still work?
Thanks Raja, yes sir the formula still works.
Very helpful, but what if there is no "cancat" option in excel in that scenario is there any replacement for same?
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),""))
Is their any other formula without concat and textjoin formula
Sirji pls explain this formula...
Thank you in advance
Sure Santosh Todkar!!!
@@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..
I like this craziness. Don't worry, I will create a video explaining the above formula!
@@MDataFinnovatics Thank you sirji
Amazing trick sir ji 👍
Sir great video
Maine sir substitute function 26 times kiya output aa gaya
Kya ye sahi h
Saurabh, aap substitute function bhi use kar sakte ho bahut wo bahut lengthy formula ban jayega (26 times substitute function).
@@MDataFinnovatics ok sir thanks
Please explain 😊😊
I am using Excel 2019 this is showing only one character. There is any problem in Excel 2019.
Mangroo, there is no problem in Excel 2019. Please validate that none of the steps are missing.
Thers no concat in my excel so its uswless for mw
Hello Amrita ji, you can try the other ways also.
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
Kannan, please elaborate your question!
@@MDataFinnovatics Gm, Sir to join text in excel version 2016
Textjoin Or concat functions are not available.
@Kannan, Textjoin and Concat functions are available only in the 2019 version or later. They aren't available in Excel 2016 or earlier.
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
Yes, you can also extract the characters only. Same things is explained in the video if you notice!
remove unwanted characters does not work in my computer. please solution.
Sir how to split the number and text like this
304 - Ganesh street
The easiest way is using the text to columns option and use "-" as others delimiter.
i want 1 formula, that can i auto fill vendor name as per type there product name
Please explain your query in detail with example.
@@MDataFinnovatics I have my data. That i required when I type product name after that next column auto fill with this product vendor name
Sir kindly explain this formula
Sure Cuto!!
Please explain this formula sir
Sure Vijay. Lets get few more comments. Don't forget to share the video with your friends!!
In my laptop this formula is not working
It's not working
Its not working for me..
Please 🙏
Not working
Hi
Hello Harsha
Please explain the same
Okay Kamal Deep Sharma.
Formula samjna hi hai
Okay Anilkumar, we will create a video on that very soon!
@@MDataFinnovatics thank you very much, all very interesting excel formula videos
It will not work with special characters like @#&%etc
Are yar ye formula kaam nahi kiya