Extract Numbers from Text in Excel Part 1 | Excel Easy Tricks - How to Separate Numbers from Text

[@Kingx7565]

You are Excel SuperStar best Teacher ever Thank you

[@Innozant]

Thanks Hasnain... Happy Learning ❤️

[@mplsoft1]

u r the most knowledge full person on excel on you tube I have ever seen. and your teaching style is superb. god bless you. doing good work. keep it up

[@Innozant]

Thanks Manoj Ji.. Really means a lot to me ♥️♥️

[@PradeepKumar-hd1ty]

Aapke jaisa videos koi nhi banata hai excel ki ! Thanks

[@Innozant]

Thanks Pradeep ❤️😊🙏Happy Learning and share with your friends to learn.

[@navalpalsingh6959]

Love the way u explained !!!

[@ITTrainerSofcon-Sec6]

Sir bahut achha concept h
isi tarah ki video banaiye sir
Thank you very much sir

[@amitsingh-is6hl]

Best teacher. I love your way of teaching sir..Love from Delhi

[@Innozant]

Thanks Amit ji❤️

[@shahzadmahmood717]

excellent

[@letsdesign786]

Behtareen Sir bohat umda treky se smjhaya ha..

[@Innozant]

Thanks Fazal❤🙏🙏🙏

[@sudhasomasundaram1509]

You are simply the best!

[@tejpalsain1507]

यह मेरे लिये बिल्कुल नया था।
मजा आ गया सर।

[@Innozant]

Thanks Tejpal Ji,Hope apko samjh me aaya hoga..Ab practice file download karke ek baar khudse bhi kar lena practice.

[@tejpalsain1507]

@@Innozant ok sir

[@stevencastelino4175]

I like your way of teaching and when my output does not come in excel I feel uneasy,your videos have helped me alot,would request you to keep on doing the great work

[@Innozant]

Thanks dear

[@emadmadi1967]

Excellent job and clarification thanks for your time

[@Innozant]

Thanks dear.Keep learning ❤️

[@dynamic_duo157]

Nice explanation with innozant smile

[@Innozant]

Thanks ❤️❤️

[@REIMANMAN7282]

Istext and numbertext se bhi ho jayega n sir

[@Excelpro75]

Excellent explanation sir. Thank you. I am too much frustrated🤣🤣 always with like these problems. Now solved smoothly.

[@Innozant]

Thanks Dear Basheer ,Hope you are able to understand this step by step and also able to explain to others as well .Seekhne Ka matlab khud tak Nahi ..aisa seekhiye ki dusron ko bhi seekha saken. Happy Learning dear.🙏❤️

[@ganeshchandra3726]

Really time saving tricks.

[@devenderkumar1220]

Excellent Guruji👌👌🙏🙏

[@dilshadahmed2200]

Love from Pakistan 🇵🇰
very easy way to guide excel formulas

[@Innozant]

Thanks dear ❤️

[@nitishpradhan7375]

o bhaishahab😱😱😱😱kyaaaa battt
he sirr
😘😘

[@Innozant]

Thanks dear

[@divyanshkhorwal3704]

you are great sir.

[@techhunt301]

Sir asa koi trick hai kya jisme (number se hi number) extract kiya ja sake sir please reply

[@Jasimuddin-dq3bx]

BEST EXPLANATION.

[@goodness377]

Excel Guruji perfect teaching concept

[@Innozant]

Thanks Dear

[@shubhammeshram8504]

Excellent teaching 🙂

[@mohammednawaz1706]

Thank you sir bcoz of you i understand these lenghty formulas no words for your explanation

[@Innozant]

Thanks Mohammed Nawaz for this lovely comment.Will try to make awesome content always.🙏❤️

[@indranimukherjee8994]

More interview oriented vdo chaiye. Thanks for sharing😊.

[@Innozant]

Thanks Indrani..Kindly watch our live interview and interview cracker playlist dear for more interview questions

[@rathvaarvind4024]

VERY SIMPAL TEACHING SIR.. AND GREAT SIR

[@Innozant]

Thanks Rathva❤️❤️❤️

[@ArvindBhushan]

if numbers like PAN card. ASWBP7156H. what furmula use.

[@MONIKASHUBHAMPAL]

Hello sir
One question hain aap se
Excel main
Joint no agl alg kaise kare
33
34. Ye no agl alg box main kaise kare plz batao sir.... @

[@dhirajsuryawanshi4510]

What the results for the 9 and 10 row no

[@shivsahu7206]

Kisi colum ke cell me alt se bana kar kafi data hai usme se particular data ko remove karna hai jo next colum ke cell me hai plz help us

[@amitambaliya4297]

Excellent

[@ismailafridi7028]

Sir i did not understood kon si range range ma kia find kra ga min lgana sa somebody answer me

[@sudhashy0]

Hats off sir, the way you teach is the best way for anyone to catch the subject very easily. 🙏 Thank you

[@Innozant]

Thanks Sudha ..Happy learning.. Gof bless you. Dear

[@antarabasak1055]

just wonderful. :) thank you

[@Innozant]

Thanks dear

[@rajeevpal2768]

Sir, fleas fill use nhi kr sakte hum es condition mai.

[@Innozant]

Kara sakte hain use but kaam krte time but interview me aapko fornula hi use krna hai dear.

[@JaswantSingh-jt2ju]

Sir ek questions hain please help kare
Jaswantsingh
Vikasarora
Ankitmishra
Sandhyasingh
Ye wale text ko extract kaise kare interview main ye questions pucha gya tha but hua nahi

[@javedamu]

Can I use substitute for this??

[@Innozant]

Kindly explain how?

[@jaswantsinghtomar3694]

Tussi great ho ji

[@Innozant]

Thanks Jaswant sahab🙏😊❤️

[@vishaltanwar8318]

Sir agar ese split karna ho to
add(87864) ye kaise split hoga ?

[@shivamonestop380]

Wah sir ,yahi to chaiye tha

[@ashubedi4078]

Awesome 👌

[@divyanshkhorwal3704]

thank you so much sir

[@excellenciamadhapur9174]

Sir Ji You are excellent and very good explanation aapko pranaam..!

[@Innozant]

Thanks Dear..HV a wonderful career ahead👍🙏❤️

[@hemantgusain1260]

Thankyou sir for giving us very useful knowledge.

[@Innozant]

Thanks Hemant for such a valuable feedback.Happy learning and share

[@MsExcelPakistan]

Sir very nice your videos and very help full

[@Innozant]

Thanks Mahmoof sahab

[@tejpalsain1507]

Super hit vedio Sir.

[@naeemkhan-tm9hx]

Today i learned something new interesting and unique....superb and tremendous video

[@Innozant]

Thanks Naeem Sahab,Hope You may able to understand the concept.

[@naeemkhan-tm9hx]

@@Innozant nice concept...and all videos are unique

[@saifullahkhan8799]

Thank you, sir

[@aisurjyasamantaray3346]

@innozant, how to extract data from a sentence like.
Ram has 200 rupees in 4 wallet.
I just want to extract 200 from this line

[@rdvaishnav1649]

Sir ji bina farmula ke text aur number alag kiye ja sakte he kya?

[@Innozant]

Haan kyu nhi..using Power query

[@technosolaraustralia621]

What is the formula to get 3 number from the row for example LG405N2T-L5 we need to extract only 405 only , or from SPR-P3-400-COM-1500 we need to extract 400 only

[@devendernegi4061]

Sir substitute lga k bhi to kar sakte the?

[@Innozant]

Yes..❤️👍

[@VishalSingh-jg2iy]

Sir hme.mis class Krna hai .. office ya online dono me kr skte hai pls suggest kre kaise start kre

[@Innozant]

Hello Vishal ji..offline aur online dono batchesil jayenge aapko.
November me new batch start hone ja raha hai ,aap immozant website visit kar sakte hain details ke liye ya call kar sakte hain fir career guidance

[@SudeshRVats]

not working correctly in google sheet
Need first occurance of any numeric in cell

[@harivanshgautam3424]

I did not knew how to solve this type of question regarding mixed text and number. It is really a in and out question. Very precious video 🙏 waiting for your next video 🙏

[@Innozant]

Yes on Coming Saturday ..Excel Tips and Tricks 2nd part will be uploaded

[@MohanKumar-uk1gj]

Sirji how to extract text in 2358skoda..I tried could not get the output..

[@Innozant]

Will make video for the same soon

[@MohanKumar-uk1gj]

@@Innozant Thank you ji

[@MansiSharma-cp8yo]

Nobody teaches like u sir

[@Innozant]

Thanks Mansi..Have a wonderful career ahead ❤️

[@digitalgyaan1782]

Notpad open karte to code dikhay deta hai isme koy workbook me password lagaya vo password dekhay dega??

[@birendrachoudhary1325]

Hello sir
Q is....how to paste the data "from one filtered sheet" to "another filtered sheet" ??
Please guide me.

[@sunilgodara8645]

..bro..please solve my problems...
Data has two types..one is numeric and second one is alphanumeric....
When we press ok button in computer then OK is what kind of data numeric or alphanumeric..
And second question is i give a command to computer that convert a 1080p video in 480p resolution..then what kind of data it is...

[@cyntherrera8738]

Hello Innozant. Thank you. Although I cannot understand what you were saying but since you have demonstrated it carefully, I was able to extract the numbers from the mixed
alphanumerics characters. Thank you again.

[@Innozant]

Thanks Cynt Herrera for watching Videos and learn from there,I hope you are able to understand the concept to extract the numbers from mixed data.
This Channel I started for Hindi Language viewers soon I am trying to add English subtitle.🙏❤️🙂

[@sandeepaswal8944]

Sir Your videos are always very helpful and have always inspired me to learn something new from you.

[@sandeepaswal8944]

Sir aapsai yai puchna hai ki example {1,2,3,4,5} , { } esh sign ko aapnai Hash Array kaha hai.
Esko team array & squiggly brackets bhi bol saktai hai kya?

[@yashpatil3375]

Exllent sir ji 👍 amazing

[@dileepmaurya5632]

Sir your all question is logically and your explanation is super as well. Thanku so much for sharing these questions 🙏🙏

[@Innozant]

Thanks Dileep Maurya Sahab...for your such a lovely appreciation ❤️👍🙏

[@NirmalKumar-cp4nf]

Sir jo apne chhoda hai usko to substitute se kr denge but lengthi hai

[@Innozant]

Optimze krke kriye use

[@AM-gc4ll]

Thank you

[@RahulKumar93555]

Nice Sir

[@swetaawasthi7036]

Can we use this Find function in excel 2013 version

[@Innozant]

yes Sweta..Why not ..even it is available in earlier version too..Hope you are learning step by step from video tutorial.. Happy learning dear

[@nafeesahmedkhannafees2857]

Dear Sir, Can we sort and sum the Numbers in one cell value for example ( Milk 2, Roti 15, Rice 350) can we extract number in this cell like =2,15,350 and make sum of it (2+15+350) Please please guide me in this regards ,, thanks a lot for your lovely way of teaching

[@excelforeveryone2657]

awesome

[@Innozant]

thanks dear

[@harahkumar6308]

Sir missing serial number pe koi video he aapki?

[@Innozant]

Yes ..excel maharaj series me

[@sanjibmondal6777]

If pattern is given like this...1111aaaa then how can I found. I have tried but not succeeded. Kindly help

[@Anil-Dgt]

Hello sir, MIS Executive ke resume ke sample pe video banaye,

[@Innozant]

Hi Anil ..already cv format diya gya hai..aap career guide playlist me Jake dekhiye video hai is topic par aur cv format bhi rakha gya hai

[@roshnijha7337]

Thank you thank you thank you so much sir

[@Innozant]

Thanks Jha Ji.❤❤🙏🙏Happy learning

[@umairzahid3743]

sir apny sikhaya the k jab bi arry formula lagaty hain to Cntl+Shift press krty hain.

[@Innozant]

bilkul sikhaya tha dear..kha issuw te btaiye phir main btata hu ki yahan ctrl +shift+enter kyu nhi use kiya

[@pareshparikh7944]

Very good sir
Happy independence day sir

[@Innozant]

Happy Independence Day

[@ajaysaroha2539]

sir,i could not understand about find() return 9 and max () return 4 pls explain it if you can...

[@Innozant]

Unable to explain through comment..You may connect me tomorrow live via zoom ,Will try to clear your doubt.🙏♥️

[@ajaysaroha2539]

@@Innozant how can i join through zoom?

[@iqratariq6850]

Excellent. very helpful. thank you!

[@Innozant]

Thanks Iqra Tariq..Happy learning

[@neerajbhushan3100]

Thanks to u Sir

[@gautamsanyal9540]

Plz give an universal formula for making entry PAN Number in a Cell through Data Validation.

[@pradeepkhan1]

Same how I do in ms access plz help me

[@Musicalsonu88]

Great sir🙏🙏

[@Innozant]

Thanks Sonu ji

[@ferozkhilji6357]

Sir how long will come 2nd part of this video

[@Innozant]

Coming Saturday Tips and Tricks Playlist

[@lokanathsahu2651]

Sir I did that the same procedure but answer is not showing correctly ,cells fill up side to side automatically. exactly what's the issue I don't know .please give me the solution

[@Innozant]

Kindly recheck you are doing wrong somewhere while applying Formula

[@pradeeprawat5591]

nice sir

[@Innozant]

thanks

[@somendrashrimali]

For example asdd1234sss12, babbsh2335ss12, gaggsg12ss-2344 how to extract 4 digit no , sir please explain.

[@Innozant]

Wait for this solution..soon.uoloading in excel maharaj

[@nishimundan9414]

Hai I need to know how can we write number in words

[@Innozant]

Yes .We can

[@RamSingh-ol5xz]

Super

[@RamSingh-ol5xz]

Top number 1 super

[@Innozant]

Thanks Ram..hope samajh aaya hoga ye concept

[@hemantgoyal409]

Sir how to extract text from this data through vba code

[@Innozant]

Okm.will make video in vba series later

[@swasi001]

Really appreciaye your way of considering complex and different senarios of different excel finction and formalae uses. Usually do not find this in topic wise videos of other instructors. Started following you recently and amazed by the information and different complex queries you share in the videos for each topic

[@Innozant]

Thanks Wasi..Happy learning..God bless you

[@mdmohsin6477]

Sir aap k mobile app h
Sir mujha advance excel course krna h

[@Innozant]

Aap channel se seekh sakte hain ya live class join kar sakte h

[@sohelshaikh932]

Hello Sir,
1 article he 1000 words ka..or usme bohot sare keywords he different different place pr.
But ab muze sirf keywords delete krna hai. So how can I delete it.
And I'VE 500 ARTICLES like that...
500 articles=500 Keywords

[@Randontutorials]

Find and replace use kro

[@sanjayrathore8599]

Sir mujhe amount nikalna he amount na left me he na right me mid me he sir us amount wali cell formula bhi use ho rakha he amoun kese nikale

[@Innozant]

Data format share kijiye kya hai example aur Karna kya chahte Hain extract Aise nhi samjh pa Ra hu apki query Sanjay ji

[@sanjayrathore8599]

@@Innozant sir data telegram par send kar du

[@Innozant]

Haan Kar dijiye..time milega to dekhta hu

[@satishojha6240]

Happy independence day sir

[@Innozant]

Happy Independence day dear

[@mohdnasim2575]

Hello sir,
First thank you so much sir,
sir know I got MIS job
Now I decided to Learn for Data analyst but I little bit confused from where I have to start
what should I have to learn first
SQL
Tebleau
or Purchase Any course
please help.

[@Innozant]

Hi,First complete your Advanced excel followed with SQL ,VBA &power bi for Data analytics or BA profile job

[@Asifkhan-yr4ld]

I think sir agar aap iss question mein left mein digit aur add karenge to yeh formula kaam nahi karega.

[@stevencastelino4175]

Sir This formula is also great which you thought on video
=Substitute(Substitute( Substitute (cellreference,1,"),2,"),3")

[@vikasbaraddi9146]

God bless u

[@Innozant]

Thanks Vikas ji❤️🙏