How to Convert Text to Numbers in Excel (5 Ways!)

Поделиться
HTML-код
  • Опубликовано: 19 авг 2024

Комментарии • 213

  • @PresentationProcess
    @PresentationProcess  2 года назад +5

    Complete Excel Foundation Course: shop.presentation-process.com/p/complete-excel-foundation-course

    • @akamstech8184
      @akamstech8184 2 года назад

      Good day, I'm Akamstech i really need a help from you, i have a Data in excel, which is mask but i can't un_mask it or set it back again. the data is just like this ( 054239**** ) i want to restore the missing number back, please sir can you help out, my work and life depend on it.

    • @Aidits9442
      @Aidits9442 8 месяцев назад

      Bro help chahiye. I ll pay

  • @sylverebryan8256
    @sylverebryan8256 3 года назад +8

    Thank you so much. After watching more than an hour of videos, I finally found a way to change my text into numbers without distorting the numer. I really appreciate your video.

  • @adamkamundi9879
    @adamkamundi9879 Год назад +1

    Finally, the replace comma function did it for me. Thank you !

  • @NeelB3640
    @NeelB3640 2 года назад +4

    Very easy direction, clear, concise, and to the point. You do not boast about subscribing to your channel. Very humble and your an excellent teacher!

  • @jean-francoisplante4347
    @jean-francoisplante4347 Год назад +1

    ctrl-h saved my life. Thank you!!

  • @rajivsukumaran
    @rajivsukumaran 3 года назад +1

    Thank you so much. It was very useful

  • @erick.rodrigues86
    @erick.rodrigues86 Год назад

    "Paste Special" did the trick perfectly! Thank you very much, my friend! Now I can filter my data. 💪

  • @Chris_Coar
    @Chris_Coar 2 года назад +2

    I totally forgot about the Replace option, thanks man

  • @swamy96769
    @swamy96769 Год назад +2

    Your explanation is easy, clear, your voice also very clear, keep it up bro

  • @deafdogdesign
    @deafdogdesign 2 года назад +3

    A very big THANK YOU!! Been searching for hours on why my function wasn't working and how to solve the issue!!

  • @ca.ravigoyal8128
    @ca.ravigoyal8128 2 года назад +1

    Dhanywaad RamGopal for tell us many ways to convert a number.

  • @mustafadarrar5880
    @mustafadarrar5880 3 года назад +1

    You're God sent. Thanks brother.

  • @sherishahmir
    @sherishahmir Год назад

    Thanks for the solution, perfectly work out.

  • @jenifferlee3571
    @jenifferlee3571 2 года назад +1

    thanks for saving my day!!

  • @datalab365
    @datalab365 2 года назад +2

    Very useful brother.

  • @joshuacampbell5673
    @joshuacampbell5673 Год назад +1

    Thank you! The Replace all worked very well, especially when I needed to delete numerical units that were included in the cells.

  • @nurinarifah9091
    @nurinarifah9091 3 года назад +2

    Thank you sooo much!

  • @AnilSingh-mj6lj
    @AnilSingh-mj6lj 2 года назад +1

    Brief Video but Very Clear and Helpful!

  • @cadeepakgoyal7500
    @cadeepakgoyal7500 4 месяца назад

    Thank you very much. really helpful. god bless you

  • @cmazloomi
    @cmazloomi 2 года назад

    Genius! The best part is that with, special paste, text to columns and value function methods, you can convert the entire column. Microsoft support says this is not possible!! Brilliant solution. THANK YOU.

  • @harshalpatil2111
    @harshalpatil2111 3 года назад +2

    Lovely ... So nice !!

  • @rakeshsingh9323
    @rakeshsingh9323 Год назад

    thanks for this video i was totally confused on green signal in sheet , but after watching this video my confusion is clear again thanks for this.

  • @divyarao8075
    @divyarao8075 2 года назад +2

    Thanks a lot ! You made my day. 😊

  • @ngoclanie6687
    @ngoclanie6687 3 года назад +2

    Thank you, finally, I found the way to solve this problem instead of tapping all of them again!

  • @MyselfAdityaSingh
    @MyselfAdityaSingh 3 года назад

    Thank you very much......bahut bahut dhanyawad

  • @Boerikoe
    @Boerikoe Год назад +1

    Excellent video, clear, and straight to the point ! Thank you :)

  • @ionutmoromete7186
    @ionutmoromete7186 2 года назад +1

    It helped me. thanks

  • @jitendersingh9757
    @jitendersingh9757 3 года назад +1

    Thanks you for your support
    Sir

  • @Shalini-Dh
    @Shalini-Dh Год назад

    thnx finally i got for what i was looking for..

  • @harishdamo3905
    @harishdamo3905 2 года назад

    Thank you so much, replace the comma helped me a lot

  • @genakjain
    @genakjain 3 года назад +1

    very helpful and clearly spoken post, one of the best i have seen in you tube, keep it up please.

  • @karilockhart2654
    @karilockhart2654 3 года назад

    I have spent hours searching for a solution to a messy Etsy CSV file to no avail until the last step in your video. Thank you SO much! Subscribing now!

  • @paolamonnihenderson
    @paolamonnihenderson Год назад

    Great video! The last trick you presented worked for me. Thank you!

  • @muhleraymond3386
    @muhleraymond3386 2 года назад

    BRAVO!!!!!! HELPFUL

  • @chopensaji208
    @chopensaji208 3 года назад

    Thank you very much sir. Solved the calculation problem while copying data from option chain to excel.

  • @maksudhasan8489
    @maksudhasan8489 Год назад +1

    Great content. I really appreciate. Thanks.

  • @sameerhadwal5204
    @sameerhadwal5204 Год назад

    Thank you, it's great help

  • @tasneembrnawi3083
    @tasneembrnawi3083 2 года назад

    Thank you so much u have saved my FYP

  • @radhakv141
    @radhakv141 2 года назад

    Thank you for your nice explination of various methods, which helped me a lot in converting a large data into numbers.

  • @mrCetus
    @mrCetus 2 года назад

    Thanks for a very comprehensive video. Worked a charm.

  • @nataliiaiatsenko7779
    @nataliiaiatsenko7779 Год назад +1

    Thanks a lot!

  • @YoSoyPalomo
    @YoSoyPalomo 3 года назад +1

    great!!! What a big problem solved without formulas

  • @madhavtewary2421
    @madhavtewary2421 8 месяцев назад

    Extremely useful video sir

  • @malcolmmac7797
    @malcolmmac7797 Год назад

    Great vid, text to columns worked for me. Cheers mate

  • @souravlohan5873
    @souravlohan5873 3 года назад +1

    thanks a ton. Saved a lot of my time

  • @davida6146
    @davida6146 4 года назад +1

    THANK YOU!!! I needed to convert a large list and using the tags took forever!!! The text to columns method was instant!

  • @veenav9967
    @veenav9967 3 года назад +1

    Very very good

  • @nileshbadekar3504
    @nileshbadekar3504 2 года назад +1

    Thank you bhau

  • @santoshmallur7035
    @santoshmallur7035 Год назад

    Thank you, sir!!!

  • @yeshosingh5897
    @yeshosingh5897 Год назад +1

    Excellent tutorial - clear and to the point .

  • @rayc9297
    @rayc9297 3 года назад +1

    Found text to column works the best! Thanks for the tips, Your videos really helps a lot of frustration.

  • @pennyyanke2562
    @pennyyanke2562 3 года назад +3

    Thank you, I've been struggling with this for a long time

  • @azman73681
    @azman73681 3 года назад

    Thanks. Excellent. U solved my problems with all available solutions in a simple straight fwd method.

  • @abichenvaazha
    @abichenvaazha 2 года назад

    4th Option is easy,, Thanks

  • @kofi-tawiahagyeman
    @kofi-tawiahagyeman 3 года назад

    Wow!!! Concise & Precise!!!

  • @Sharvank9191
    @Sharvank9191 2 года назад

    A big thanks to You

  • @worthityoutube1
    @worthityoutube1 2 года назад

    THANKS & GREAT FOR SIMPLE BUT WONDERFUL TIPS

  • @manojroy2687
    @manojroy2687 Месяц назад +1

    THANKS

  • @ansh-singh
    @ansh-singh 2 года назад +1

    I found valuable it helped me a lot

  • @vishalbrahmbhatt157
    @vishalbrahmbhatt157 3 года назад

    Excellent.. Please make such more vidoes that can save huge amount of time in office.. On routine work

  • @adambevan2423
    @adambevan2423 2 года назад +1

    brilliant! method2

  • @jagadishmohanty4728
    @jagadishmohanty4728 3 года назад

    Thanks for useful formulas. Thanks a lot

  • @uditjariwala2551
    @uditjariwala2551 3 года назад

    Thanks A Lot... Many videos have seen on YT but sir ji only you have put the solution for coma numbers

  • @pravinghanchi4093
    @pravinghanchi4093 Год назад

    Thank you- helpful

  • @RayRay-lj9zb
    @RayRay-lj9zb 4 года назад +1

    Great guy!
    ...Saved a soul

  • @noorifayaz6714
    @noorifayaz6714 3 года назад

    Thank you buddy, I have gone through with your video and tried all the tricks, but to my surprise only last trick worked. kudos to your video and you as well. all the best

  • @Nogxme
    @Nogxme 4 года назад

    im in the middle of a class lesson , the teacher keeps making a theater presentation when people ask him questions, so happy i got help from this instead

  • @aamirkhawaja3072
    @aamirkhawaja3072 2 года назад +1

    Thanks

  • @bukolaadebayo1891
    @bukolaadebayo1891 2 года назад

    Very concise and helpful. Thanks!

  • @eminimamoglu3072
    @eminimamoglu3072 3 года назад

    You saved my life. Thanks

  • @radhakv141
    @radhakv141 2 года назад

    Thank you for your nicely explained detailed video which helped me a lot.

  • @nareshjoshi165
    @nareshjoshi165 3 года назад +1

    Thank U so much

  • @banushasathi3526
    @banushasathi3526 3 года назад

    Thank you so much. Really help full.

  • @sqoches
    @sqoches 4 года назад +2

    Thank you very helpful, I had a space issue with my numbers in text format.

  • @SurajKumar-wj7dc
    @SurajKumar-wj7dc Год назад

    Thanks sir 🙏 so much

  • @ivanomatijevic8822
    @ivanomatijevic8822 2 года назад

    Thank you, you saved me a lot!

  • @rizan333
    @rizan333 2 года назад

    This really helped me bro. Thanks a lot

  • @jodavila16
    @jodavila16 3 года назад

    Freat Video, Thanks!!

  • @alokbansal3511
    @alokbansal3511 2 года назад

    Nice presentation sir it help me lot, Thank you very much

  • @shajibkumarguha234
    @shajibkumarguha234 4 года назад

    Really helpful. For large number of data, second option is the best.

  • @shubhamvashistha4369
    @shubhamvashistha4369 2 года назад

    Thank you 😊

  • @matthewbutler9328
    @matthewbutler9328 2 года назад

    This is exactly what I was looking for, thank you.

  • @kristofrancis3064
    @kristofrancis3064 3 года назад

    Thank you, smartly presented

  • @vikasgupta-ts8ek
    @vikasgupta-ts8ek 3 года назад

    Good One Thanks i was very Helpful.

  • @madhusudhanaraoalampally4342
    @madhusudhanaraoalampally4342 3 года назад

    Excellent explanation

  • @miloshalda2031
    @miloshalda2031 3 года назад

    This was a helpful video. Thanks!

  • @naledieabochabelamoyo5018
    @naledieabochabelamoyo5018 3 года назад

    Thank you so much- this was really helpful

  • @sambitguru8374
    @sambitguru8374 2 года назад

    It was really helpful. Thanks a lot.

  • @Jay_Ho992
    @Jay_Ho992 11 месяцев назад

    Very useful

  • @ntaylor81
    @ntaylor81 4 года назад +3

    Thank you! Was looking for a solution for so long! The Control H did the trick!!

  • @izurukira1160
    @izurukira1160 3 года назад

    Thanks 👍🏻

  • @badtank9020
    @badtank9020 3 года назад

    You Sir are awesome! Thank you so much!

  • @samvictor1665
    @samvictor1665 Год назад

    Brilliant,

  • @navaskmk
    @navaskmk 8 месяцев назад +1

    usefull love it

  • @balachandranm8300
    @balachandranm8300 3 года назад

    Oh My God ! Thanks allot to you sir
    A very useful video

  • @wingwong8670
    @wingwong8670 2 года назад

    very useful.

  • @fyreOwlTrue
    @fyreOwlTrue 2 года назад

    Thank you

  • @ayyappan2703
    @ayyappan2703 3 года назад

    Thanks got solution

  • @reteblack
    @reteblack 3 года назад

    Thanks you bro

  • @hazemsultan9284
    @hazemsultan9284 3 года назад

    I Love u, u solve for me a problem :)