How To Separate Numbers From Text In Excel || Excel Tips & Tricks || dptutorials

[@DarlitaDawn]

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.

[@dptutorials]

Fantastic!, These comments are motivating me for sure.

[@novasilas9306]

i know Im pretty randomly asking but do anybody know of a good place to watch newly released movies online?

[@chewturgeon9066]

finally, someone who can answer the dang question...simply and thoroughly... Nice work!

[@dptutorials]

You're welcome!

[@pramodmangale5481]

What if we have text like 1.5mg 200g 0.50gm

[@Estategrow13]

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!

[@dptutorials]

Glad it was helpful!

[@frankyfernandes6283]

This another level of Excel knowledge. Feeling like I know nothing in Excel😀. Thanks.

[@bogdanbarac9558]

Thank you, helped a lot with my final paper.

[@dptutorials]

Wow!! Most welcome, please subscribe for more videos.

[@AB-yf8bz]

Bro, you should have mentioned what last three functions (min, left & substitute) does in the formula, to make it really learning. Thanks

[@chrisnoonan1661]

Thank you! I never used these formulas before. It worked.

[@mrs.parker215washington6]

THANK YOU SOOOOOOOOOO MUCH!!!!!! Very clear instructions and you explained what each part of the formula represented. :-)

[@stephenagu7520]

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.

[@dptutorials]

Glad it was helpful!

[@vandanavinod1927]

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 😘😘😘

[@ayyodele]

Thank you for making it simple and straight forward

[@BaycarlEnterprise]

You’re amazing bro…this saved me a lot of time today 👊🏽

[@dptutorials]

This is so inspiring. Thanks a lot.

[@kenasingho102]

Very helpful, Thanks!

[@dptutorials]

Glad it was helpful!

[@VenkatTheBiker]

Thank you it helped me with my HR works

[@dptutorials]

Glad it helped

[@BetterlifeNowinnerpeace]

Thankyou so much, this was very helpful

[@dptutorials]

Glad it was helpful!

[@chirathharshane7017]

You saved my life! ❤

[@dptutorials]

Thanks a lot

[@NoorAli-hu7ct]

THANKS -YOU ARE A HERO

[@dptutorials]

Wow, this is inspiring.

[@firefighterAk]

It Works.... Thank you sir👍

[@davidmtutu2563]

Brilliant, it worked the first time. Thank you :)

[@dptutorials]

Glad it helped

[@ganeshkannan5750]

Thank you so much for this vedio, very help full ❤

[@bhaviklimbani2803]

Most helpful video on the planet❤️

[@dptutorials]

Glad you think so!

[@liamsphin]

This saved me!!

[@user-ov4dw3yr5d]

Great Man. Good guy! Thank you!

[@dptutorials]

You're welcome!

[@RahulKumar-v8e5w]

thanks alot it is working fine you saved my time

[@dptutorials]

You're welcome!

[@johnndungu2861]

Just beautiful, I loved it

[@dptutorials]

Thanks a lot.

[@info4u377]

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?

[@brantdesmond7448]

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?

[@dptutorials]

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.

[@brantdesmond7448]

@@dptutorials Thanks for the reply. I ended up getting around the problem by using the =VALUE() function.

[@draz7905]

@@brantdesmond7448 I had the same issue. Thanks for posting your workaround! :D

[@anitakartolo9279]

Thank you!

[@dptutorials]

You're welcome!

[@peishanlu5425]

It doesn't work now with the new MS excel, any idea why? :/

[@richardchirangande1949]

Thanks mate😃

[@dptutorials]

Happy to help

[@abhishekpunni818]

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.

[@swanish1111]

Thanks a lot for this important information 🍫

[@SarjanaAgel]

very helpfull, thanksss

[@dptutorials]

Glad it was helpful!

[@rajanyadav15]

Actually helpfully

[@ngocnguyen8258]

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?

[@dptutorials]

Great suggestion!

[@swarajshrma7580]

What is the solution?

[@dptutorials]

Find this trick, which would be useful for you: kzbin.info/www/bejne/aYnZm4uuirB0jtU

[@annasemisomberi]

Thank you so much ❤️😀

[@rasararavinath2415]

Wow.. Super

[@dptutorials]

Thank you so much

[@ThePatrik619]

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

[@dptutorials]

Please send me the Excel file at [e-mail]

[@porudoryu]

Nice. You saved me countless of hours. May your Gods bless you! Thank you sir.

[@dptutorials]

So sweet of you, thanks a lot.

[@FunWithKids-dr2of]

very helpfull, thanks

[@dptutorials]

Glad it was helpful!

[@dayanand7503]

It's working tq

[@pacsltdhanagandi3546]

I am use this formula it is very useful interesting and I enjoy it. Thank you Sir.

[@dptutorials]

So nice of you

[@emart262]

Yes Its Working Fine, Thanks

[@dptutorials]

Thank you! Cheers!

[@swapnilbhostekar7186]

Thanks sir 🙂

[@parvtannu]

Aswm... I hav made VBA for this 😂😂.. thank to simplify 🙏

[@dptutorials]

Most welcome 😊

[@sateshsaty9737]

Thanks man it helped me a lot

[@dptutorials]

Glad it helped

[@Marleys-pi9xk]

Thank you so much👍🏼

[@dptutorials]

You're welcome!

[@aliasjad9560]

you are amazing bro .this video is very helpful

[@dptutorials]

Glad to hear that

[@jshailesh7619]

Superb videos, just at right time. Thank you so much 🤗

[@dptutorials]

You are so welcome!

[@rachanaabhhati]

Amazing formula, I saved it ,it saves time alot

[@dptutorials]

Thanks Rachna, You are welcome 😊, Glad it helped you. Please support my channel.

[@rachanaabhhati]

@@dptutorials yes sure

[@mdmubaraq]

Thanks so much

[@dptutorials]

You're welcome!

[@rahulmathur3953]

Really very interesting and too easy for understanding

[@dptutorials]

Glad you think so!

[@viralreels2643]

It is better to use flash fill if you have ms office 2013 or later versions

[@dptutorials]

Yes, sometime when the flash fill doesn't work then this can be useful.

[@priyankpatel4029]

works bro thanks

[@Seeeeeriously]

Excellent, thanks

[@usamaalihassan1438]

Very Helpful

[@dptutorials]

Glad to hear that

[@mudassaratiq7640]

Thankyou for guidance

[@dptutorials]

Always welcome

[@pklynn9887]

Thank you so much for uploading this.

[@dptutorials]

My pleasure!

[@lisatrinidad698]

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.

[@abdelhafidassadiki2124]

It's a extraordinary & exclusive truc..

[@niyaasveecy]

Goof info I will try its very useful for me

[@dptutorials]

All the best

[@jordanarmstrong3683]

Just awesome! Thanks SO much!

[@dptutorials]

You are so welcome!

[@ismail9746]

You are awsome-thank you for your effer

[@dptutorials]

You are so welcome

[@godwinbassey5787]

Very simple and comprehensive... Thanks so much

[@dptutorials]

You're very welcome!

[@panagiotistheodorou4959]

Yes! Good one and thank you.

[@dptutorials]

Thank you too!

[@akashshukla1248]

This was a great vide. Thanks for your help.

[@dptutorials]

Glad it was helpful!

[@amandarichards7299]

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?

[@aaizu6473]

Nice video

[@seethagopavarapu743]

Thank you so much!! Very useful and informative video it saved my time. Kudos..

[@dptutorials]

Glad it helped!

[@alphanutritionthes]

not working on mac os excel there claims error type

[@MuhammadAwaisAwaisch]

GOOD ONE

[@dptutorials]

Thanks a lot

[@devenderkumar1220]

Excellent..👌👌

[@dptutorials]

Thanks a lot 😊

[@al-karimcapitalestate7336]

Helpful

[@dptutorials]

Glad you think so!

[@johnndungu2861]

Wonderful

[@dptutorials]

Thanks a lot

[@PashaHindiAcademy]

Sir I want fill the data with nuber it refers some name how I put in this

[@Gunanimbuzz]

Thank a lot...!

[@dptutorials]

You're welcome!

[@justengineer6276]

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// ?

[@seta156]

Thanks, this formula is of great help

[@dptutorials]

Glad it was helpful!

[@Kaaaaaay]

Thank you 💕

[@dptutorials]

You’re welcome 😊

[@DenkiinArt]

Hello, does this work with the number and dollar sign?

[@dptutorials]

yes, it should

[@YogiLaciste]

lifesaver

[@ishahab1000]

It's working in case Numbers are at start At any where in the string

[@WalkerB2730]

Awesome

[@vickyjohn4073]

Neat explaining thank you sir

[@dptutorials]

You are welcome

[@piyuanjani]

really thnx bro

[@dptutorials]

Most welcome

[@akshaysaxena6873]

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

[@nicosiamontgomery9234]

Thank you for sharing! I appreciate the time and effort.👍🏾

[@dptutorials]

My pleasure!, Thanks a lot.

[@chioptnstdr3448]

You saved me hours. Thank you :)

[@dptutorials]

Glad it helped!

[@goutamgolui866]

Can i solve this problem with flash fill...??

[@BhakuniMonu]

AWESOME BRO THANK YOU FOR TELLING

[@dptutorials]

Always welcome

[@daniel.shalome]

AWWESOMEEEEE

[@claesjosefsson2935]

Greate video. Thank's a lot:)

[@dptutorials]

Glad you liked it!

[@saleembaig5104]

very good video, I have a problem, cell with mix number and text but I need to remove number from right only

[@dptutorials]

*kzbin.info/www/bejne/eILChWuDndR0nM0*

[@AcademicBMCT]

Thank you, Sir.

[@dptutorials]

You are very welcome

[@stellakl5601]

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

[@anandmishra756]

Try Alt+A+E or use left or right command

[@caaneesumer6416]

Thanks

[@dptutorials]

Welcome

[@vivekchaudhari6105]

Thanks a lot ❤️

[@dptutorials]

You're welcome 😊

[@Ravi_8681]

Nice Information

[@dptutorials]

Thanks Thanks a lot for the feedback. I welcome you to subscribe to this channel to enjoy more interesting videos.

[@mdrubelhossain3494]

Impressive

[@dptutorials]

Thank you so much 😀