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 😘😘😘
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?
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.
Thank you very much for your great lesson! May I have a question about how to separate text from numbers if they are not in order, like this: C3H6O -> CHO?
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
I have a complex Excel problem for which I've been unable to find a formula to it anywhere on the internet. In fact, I'm not even sure if such a formula exists for what I want to do but I'm hoping there must be. It involves inputting a letter into a cell and getting the Total cell to recognise it as a number. The formula I have in mind is for the Total cell to look up the value of a letter by deriving the value from another cell. Any chance I could get help with it?
Is there a way to then delete the original source column without affecting the new split columns? I recognize the formula links them to the source so deleting the source column messes up the entire formula. As of now, I'm just copying and pasting values only into a new spreadsheet but was wondering if there is another way to go about it.
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
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?
finally, someone who can answer the dang question...simply and thoroughly... Nice work!
You're welcome!
This another level of Excel knowledge. Feeling like I know nothing in Excel😀. Thanks.
What if we have text like
1.5mg
200g
0.50gm
Thank you, helped a lot with my final paper.
Wow!! Most welcome, please subscribe for more videos.
Bro, you should have mentioned what last three functions (min, left & substitute) does in the formula, to make it really learning. Thanks
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! I never used these formulas before. It worked.
Thank you it helped me with my HR works
Glad it helped
You’re amazing bro…this saved me a lot of time today 👊🏽
This is so inspiring. Thanks a lot.
Very helpful, Thanks!
Glad it was helpful!
THANKS -YOU ARE A HERO
Wow, this is inspiring.
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!
You saved my life! ❤
Thanks a lot
Thank you for making it simple and straight forward
Most helpful video on the planet❤️
Glad you think so!
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 😘😘😘
THANK YOU SOOOOOOOOOO MUCH!!!!!! Very clear instructions and you explained what each part of the formula represented. :-)
Thank you so much for this vedio, very help full ❤
thanks alot it is working fine you saved my time
You're welcome!
Thankyou so much, this was very helpful
Glad it was helpful!
It Works.... Thank you sir👍
This saved me!!
Great Man. Good guy! Thank you!
You're welcome!
Just beautiful, I loved it
Thanks a lot.
Thanks mate😃
Happy to help
Brilliant, it worked the first time. Thank you :)
Glad it helped
Yes Its Working Fine, Thanks
Thank you! Cheers!
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 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
Thank you so much ❤️😀
Thanks a lot for this important information 🍫
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.
Aswm... I hav made VBA for this 😂😂.. thank to simplify 🙏
Most welcome 😊
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?
Thank you!
You're welcome!
very helpfull, thanksss
Glad it was helpful!
Thanks man it helped me a lot
Glad it helped
Thank you so much👍🏼
You're welcome!
Thank you very much for your great lesson!
May I have a question about how to separate text from numbers if they are not in order, like this: C3H6O -> CHO?
Great suggestion!
What is the solution?
Find this trick, which would be useful for you: ruclips.net/video/3XvjXxUKAXs/видео.html
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
Really very interesting and too easy for understanding
Glad you think so!
Actually helpfully
very helpfull, thanks
Glad it was helpful!
Thanks sir 🙂
you are amazing bro .this video is very helpful
Glad to hear that
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
It's a extraordinary & exclusive truc..
Excellent..👌👌
Thanks a lot 😊
I am use this formula it is very useful interesting and I enjoy it. Thank you Sir.
So nice of you
Goof info
I will try its very useful for me
All the best
Wow.. Super
Thank you so much
It doesn't work now with the new MS excel, any idea why? :/
Just awesome! Thanks SO much!
You are so welcome!
Thanks so much
You're welcome!
Thankyou for guidance
Always welcome
It's working tq
I have a complex Excel problem for which I've been unable to find a formula to it anywhere on the internet. In fact, I'm not even sure if such a formula exists for what I want to do but I'm hoping there must be. It involves inputting a letter into a cell and getting the Total cell to recognise it as a number. The formula I have in mind is for the Total cell to look up the value of a letter by deriving the value from another cell. Any chance I could get help with it?
Nice. You saved me countless of hours. May your Gods bless you!
Thank you sir.
So sweet of you, thanks a lot.
This was a great vide. Thanks for your help.
Glad it was helpful!
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// ?
You are awsome-thank you for your effer
You are so welcome
Thank you so much for uploading this.
My pleasure!
works bro thanks
Thanks, this formula is of great help
Glad it was helpful!
Excellent, thanks
Very Helpful
Glad to hear that
Very simple and comprehensive... Thanks so much
You're very welcome!
Thank you 💕
You’re welcome 😊
Superb videos, just at right time. Thank you so much 🤗
You are so welcome!
Wonderful
Thanks a lot
Yes! Good one and thank you.
Thank you too!
It's working in case
Numbers are at start
At any where in the string
Thank you so much!! Very useful and informative video it saved my time. Kudos..
Glad it helped!
Thank a lot...!
You're welcome!
Neat explaining thank you sir
You are welcome
GOOD ONE
Thanks a lot
Nice video
Is there a way to then delete the original source column without affecting the new split columns? I recognize the formula links them to the source so deleting the source column messes up the entire formula. As of now, I'm just copying and pasting values only into a new spreadsheet but was wondering if there is another way to go about it.
Helpful
Glad you think so!
We can use falshfill also I think that is very easy process for this kind of dataset
Yes
really thnx bro
Most welcome
very good video, I have a problem, cell with mix number and text but I need to remove number from right only
*ruclips.net/video/BQ_T8MhoAfk/видео.html*
AWESOME BRO THANK YOU FOR TELLING
Always welcome
Thank you, Sir.
You are very welcome
Thank you for sharing! I appreciate the time and effort.👍🏾
My pleasure!, Thanks a lot.
Greate video. Thank's a lot:)
Glad you liked it!
Thanks a lot ❤️
You're welcome 😊
lifesaver
You saved me hours. Thank you :)
Glad it helped!
Awesome
Impressive
Thank you so much 😀
Thanks
Welcome
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
Hello, does this work with the number and dollar sign?
yes, it should
Nice Information
Thanks
Thanks a lot for the feedback.
I welcome you to subscribe to this channel to enjoy more interesting videos.
Thank you, great
Thank you too!
thank you sir ji
Thanks a lot for the feedback.
I welcome you to subscribe this channel to enjoy more interesting videos.
Do you know how to extract the 4th digit in an excel date? I need it for a spread sheet I'm working on. Thanks
Try Alt+A+E or use left or right command
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