You are awesome! We love you! Thank you for solving something that I had been trying to solve for two hours! Greeting from Alaska! Thank you for all that you do.
Really helpful. Our system extracts invoice numbers with vendors and I was sure there had to be a way to break it out and this saved alot of time and worked. Thank you!
Much appreciated brother 😘😊😘😊, Very Very Informative and 100 💯 working .. I was given an impossible task from my manager and with ur help I did in one short 😘😘😘
Can you please explain use on MIN function in this. I am not getting desired result using this formula as my number in text starts with 1 followed by 0 so it is siting text up to 1, so basically I am getting text as ABCD1, but when I change the order of numbers in FIND function to 1,2,3,4,5,6,7,8,9,0 it works fine and I do get text result as ABCD which I want.
how to separate when the data is quantity attached to unit. i want to separate numbers and unit to enter in separate columns. The digits might be repeating and the units are diverse
Thanks you so much for showing this. It is really helpful. I have one question. Please help to separate this Acrobat Survellance SEV0XF_A 2/18/2022 into first part and the second part would be only date. Please help this
Thanks for your tutorial. It was very informative, however I have found that I cannot use the SUM function on the numbers that have been separated from the text. Is there a workaround for this?
When trying this formula and even changing the order of the FIND numbers (1,2,3,4,5,6,7,8,9,0) my cells appear blank and the substitute formula appears with the original ref cell. What am I doing wrong?
You are awesome! We love you! Thank you for solving something that I had been trying to solve for two hours! Greeting from Alaska! Thank you for all that you do.
Fantastic!, These comments are motivating me for sure.
i know Im pretty randomly asking but do anybody know of a good place to watch newly released movies online?
@@dptutorials Becouse this is very different topic.
like different text and with different length.
What if we have text like
1.5mg
200g
0.50gm
finally, someone who can answer the dang question...simply and thoroughly... Nice work!
You're welcome!
Very helpful, Thanks!
Glad it was helpful!
Thank you, helped a lot with my final paper.
Wow!! Most welcome, please subscribe for more videos.
Thank you! I never used these formulas before. It worked.
Thank you it helped me with my HR works
Glad it helped
Waoo this is amazingly great I have been looking for how to do this especially when I have huge data to work with. Thank you so much.
Glad it was helpful!
This another level of Excel knowledge. Feeling like I know nothing in Excel😀. Thanks.
Thanks sir..awsome...❤
Glad you found it helpful!
Really helpful. Our system extracts invoice numbers with vendors and I was sure there had to be a way to break it out and this saved alot of time and worked. Thank you!
Glad it was helpful!
Thank you so much for this vedio, very help full ❤
Thankyou so much, this was very helpful
Glad it was helpful!
Thank you for making it simple and straight forward
This saved me!!
THANKS -YOU ARE A HERO
Wow, this is inspiring.
THANK YOU SOOOOOOOOOO MUCH!!!!!! Very clear instructions and you explained what each part of the formula represented. :-)
You’re amazing bro…this saved me a lot of time today 👊🏽
This is so inspiring. Thanks a lot.
You saved my life! ❤
Thanks a lot
Just beautiful, I loved it
Thanks a lot.
thanks alot it is working fine you saved my time
You're welcome!
Thanks sir 🙂
very helpfull, thanks
Glad it was helpful!
Thank you!
You're welcome!
Great Man. Good guy! Thank you!
You're welcome!
Much appreciated brother 😘😊😘😊, Very Very Informative and 100 💯 working .. I was given an impossible task from my manager and with ur help I did in one short 😘😘😘
It Works.... Thank you sir👍
Most helpful video on the planet❤️
Glad you think so!
Thank you so much ❤️😀
Thanks mate😃
Happy to help
very helpfull, thanksss
Glad it was helpful!
It's working tq
Actually helpfully
Thanks a lot for this important information 🍫
not working on mac os excel there claims error type
Yes Its Working Fine, Thanks
Thank you! Cheers!
Sir
I want fill the data with nuber it refers some name how I put in this
It doesn't work now with the new MS excel, any idea why? :/
Brilliant, it worked the first time. Thank you :)
Glad it helped
Thanks so much
You're welcome!
Wow.. Super
Thank you so much
It is better to use flash fill if you have ms office 2013 or later versions
Yes, sometime when the flash fill doesn't work then this can be useful.
Thanks man it helped me a lot
Glad it helped
It's a extraordinary & exclusive truc..
Thank you so much👍🏼
You're welcome!
Excellent, thanks
Bro, you should have mentioned what last three functions (min, left & substitute) does in the formula, to make it really learning. Thanks
It's working in case
Numbers are at start
At any where in the string
Really very interesting and too easy for understanding
Glad you think so!
Goof info
I will try its very useful for me
All the best
Wonderful
Thanks a lot
Amazing formula, I saved it ,it saves time alot
Thanks Rachna, You are welcome 😊, Glad it helped you. Please support my channel.
@@dptutorials yes sure
you are amazing bro .this video is very helpful
Glad to hear that
Very Helpful
Glad to hear that
Thankyou for guidance
Always welcome
You are awsome-thank you for your effer
You are so welcome
Just awesome! Thanks SO much!
You are so welcome!
This was a great vide. Thanks for your help.
Glad it was helpful!
Thank a lot...!
You're welcome!
works bro thanks
Aswm... I hav made VBA for this 😂😂.. thank to simplify 🙏
Most welcome 😊
Helpful
Glad you think so!
GOOD ONE
Thanks a lot
Neat explaining thank you sir
You are welcome
I am use this formula it is very useful interesting and I enjoy it. Thank you Sir.
So nice of you
Thanks, this formula is of great help
Glad it was helpful!
Nice video
Thank you 💕
You’re welcome 😊
Yes! Good one and thank you.
Thank you too!
Thank you so much for uploading this.
My pleasure!
Excellent..👌👌
Thanks a lot 😊
Can i solve this problem with flash fill...??
Thanks for the explanation, Any tricks to SEPARATE the text if comes after the Number ( To the right 0 e.g : 1450 mL : To be // 1450 // and // mL// ?
Can you please explain use on MIN function in this. I am not getting desired result using this formula as my number in text starts with 1 followed by 0 so it is siting text up to 1, so basically I am getting text as ABCD1, but when I change the order of numbers in FIND function to 1,2,3,4,5,6,7,8,9,0 it works fine and I do get text result as ABCD which I want.
really thnx bro
Most welcome
We can use falshfill also I think that is very easy process for this kind of dataset
Yes
Thank you for the video. I have a question, what if the data is one cell like 100 names and 100 numbers (in one cell), then what?
Awesome
Very simple and comprehensive... Thanks so much
You're very welcome!
Thanks
Welcome
Thank you so much!! Very useful and informative video it saved my time. Kudos..
Glad it helped!
lifesaver
AWWESOMEEEEE
Superb videos, just at right time. Thank you so much 🤗
You are so welcome!
how to separate when the data is quantity attached to unit. i want to separate numbers and unit to enter in separate columns. The digits might be repeating and the units are diverse
Nice. You saved me countless of hours. May your Gods bless you!
Thank you sir.
So sweet of you, thanks a lot.
I cant add these numbers by using auto summation and cant sort and cant copy paste. Help me
AWESOME BRO THANK YOU FOR TELLING
Always welcome
Thanks you so much for showing this. It is really helpful. I have one question. Please help to separate this Acrobat Survellance SEV0XF_A 2/18/2022 into first part and the second part would be only date. Please help this
Please send me the Excel file at info@dptutorials.com
Impressive
Thank you so much 😀
Greate video. Thank's a lot:)
Glad you liked it!
Thanks a lot ❤️
You're welcome 😊
Thank you, Sir.
You are very welcome
Thank you, great
Thank you too!
very good video, I have a problem, cell with mix number and text but I need to remove number from right only
*ua-cam.com/video/BQ_T8MhoAfk/v-deo.html*
Tnq so much sir
Thanks a lot for the feedback.
I welcome you to subscribe to this channel to enjoy more interesting videos.
@@dptutorials sure sir
Nice Information
Thanks
Thanks a lot for the feedback.
I welcome you to subscribe to this channel to enjoy more interesting videos.
thank you sir ji
Thanks a lot for the feedback.
I welcome you to subscribe this channel to enjoy more interesting videos.
Thanks for your tutorial. It was very informative, however I have found that I cannot use the SUM function on the numbers that have been separated from the text. Is there a workaround for this?
Hi, Check by converting the formatting the separated numbers into number format. Or'else use the text to columns to convert them into number format.
@@dptutorials Thanks for the reply. I ended up getting around the problem by using the =VALUE() function.
@@brantdesmond7448 I had the same issue. Thanks for posting your workaround! :D
When trying this formula and even changing the order of the FIND numbers (1,2,3,4,5,6,7,8,9,0) my cells appear blank and the substitute formula appears with the original ref cell. What am I doing wrong?