Extract Number and Text from Mix Data in Excel

[@lakhbirsingh2030]

Bhut video dekhe is topic per....per ek bhi video esha nhi mila....dil khus kr diya sir ji.

[@ExcelWorldmis]

Thank you so much for lovely feedback

[@deppuraghav6233]

Lovely video....or video chahiye ashe hi...thank you so much.

[@ExcelWorldmis]

Thank you....next video jald hi milega

[@sandeepjage977]

Superb ❤️

[@ExcelWorldmis]

Thank you

[@sirajtn]

Very useful information, thanks

[@rajendrakumarbarik3968]

Keep going dear

[@arnav.borah47]

It really works...... awesome. Thank you so much. Amazing

[@ExcelWorldmis]

Thank You

[@karmasinggh2561]

Very informative video for learn. Thanks for sharing

[@saleembaig5104]

Thanks very useful. I have text with mix numbers want to remove number from right only

[@nayanparmar9127]

how to extract letter form a word or number?
for example the word is "Phenomenon " & I need to extract forth letter from this word that is "N"
is this possible in excel??????????????

[@ExcelWorldmis]

As per your query there is three "N". You want in answe "NNN" or only one latter "N"

[@nayanparmar9127]

@@ExcelWorldmis only one letter N

[@KaranSharma-hz2rr]

Great Video for me...thanks for sharing.

[@ExcelWorldmis]

Thanks

[@RahulChauhan-bv1jn]

Good video...thanks for sharing

[@SwS404]

Very helpful, 👍👍Thanks Brother

[@ExcelWorldmis]

Thank you🙏

[@vikasgawaria5330]

Super hit video sir thank you so much

[@ExcelWorldmis]

Thank you

[@rnjita581]

Very helpful

[@blacksmith1830]

Thank you so much ❤️❤️❤️

[@brijnarayan1234]

very very nice bro...

[@ExcelWorldmis]

Thank You Sir for watching

[@kamlesharya7690]

Very helpful video sir ji 🙏🙏 sir agar start mein number ho jaise 100raj, 78kamal, tab kaise hoga plz reply me

[@ExcelWorldmis]

Same as in video

[@Excel_Tricks103]

Bhai agar minimum number biche main hua to fir mid start number kaha se karega

[@ExcelWorldmis]

Aap formula ko evaluate kr k dekho ek bar fir aap ko logic Samaja aa jayega.
Agr fir bhi koi issue aye to btana.

[@taisertown]

thanks bro Good Luck

[@arnabghosh4194]

Thanx sir very simply & beautifully explained

[@ExcelWorldmis]

Thank You 😊

[@PawanKumar-sx3ok]

Bhai agar cell main data without. Space ke ho to

[@ExcelWorldmis]

Sir video me jo example h usme bhi space nhi h.....agr or koi query h to example data comment kro.

[@PawanKumar-sx3ok]

PawanKumar241988 ko left right mid ko alag kaise kare give which function

[@queenofmyworld786]

Thank you so much success 💐

[@ExcelWorldmis]

Great thanks for watching

[@AmazingAnwar]

excellent thanks men

[@ExcelWorldmis]

Thank You

[@poojaraghav511]

Very well explain....keep it up.

[@ExcelWorldmis]

Thank You

[@rajeshakkineni5127]

If in case number is middle on name is it possible same formula to find out name separate

[@ExcelWorldmis]

Please share example

[@debapriyapandit5534]

I'd agar bracket k ander ho to keyse kare?

[@ExcelWorldmis]

Tb to or bhi easy h ...Left or find function use karke nikal sakte ho.

[@ImranShaikh-ye5ux]

Good one

[@ExcelWorldmis]

Thanks

[@krishnabhattarai9106]

sir employ id ko first mey na karte huwe. agar name ko nikalna hai toh kaise?

[@ExcelWorldmis]

You can use both formula in first cell

[@amarjeetsingh8537]

Lovely bro thanks for this🙏

[@ExcelWorldmis]

Thank You

[@mairajhabib9754]

Can you pl help me in extracting ""5ms"" from ""Reply from 10.12.111.1: bytes=32 time=5ms TTL=63"" ?

[@ExcelWorldmis]

Kindly share your query in excel format on [e-mail]

[@bhramanti4152]

What if start and end both have text and number is in middle.. how do I extract it

[@ExcelWorldmis]

ua-cam.com/video/5Zn67VKnZG4/v-deo.html
Kindly watch this video...I hope your query has been resolved

[@treesofeducations4159]

Great Dear ❤️❤️

[@ExcelWorldmis]

Thank you

[@pandharinathjoshi6565]

Superb sir

[@ExcelWorldmis]

Thank you

[@enlighteningbrain8247]

Very nicely explained , for this video , I m Subscribing you ,keep it up bro 👌👌

[@ExcelWorldmis]

Thank you so much.... Will upload next video very soon.

[@hemantgoyal409]

Sir how can we do this work through vba code

[@ExcelWorldmis]

Share your email will send you vba code

[@jigneshjani1309]

Very useful

[@ExcelWorldmis]

Thank You Sir

[@rohitchanda50]

Sir jii agar mixed data aisa ho to kiya kare please help 1225Raju srivastabisko kaise split kare?

[@ExcelWorldmis]

Kindly share you email id .....will share Excel sheet

[@rohitchanda50]

@@ExcelWorldmis [e-mail]

[@CR_7717]

Sir apna and ka simbal kyo lagaya hai please reply

[@ExcelWorldmis]

And ka symbol 0-9 tak text k sath add krne k liye kiya h.

[@CR_7717]

Ok sir thank you

[@rizwanansari4294]

Thank you sit

[@hemlatasingh6327]

Sir ex BR10-10136 aisi koi series ho usme s hme BR10- replace krna ho to kaise krenge

[@ExcelWorldmis]

is condition me substitute function ka use kr sakte hai.

[@vijaysahal4556]

nice 👍🏻👍🏻👍🏻

[@ExcelWorldmis]

Thank You

[@mohammedhammadahmed2168]

Nicely explained bro can you put the data sheet used in video under this video's of your tutorials thanks

[@ExcelWorldmis]

Share your email id will share with you.

[@mohammedhammadahmed2168]

@@ExcelWorldmis [e-mail] thanks in advance

[@ExcelWorldmis]

Mail sent....Kindly check

[@VijaySharma-do8lj]

Acha lga apka video par ek confusion hai like Vijay 793 alok 699 Rakesh 600 pritam 999 jese value ek cell me hai or muje ye value alag alag cell me chaiye kese kre

[@msamidireddy8084]

Please send same formula.
So that I will use the formula.
Thanks in advance

[@sunilrana6594]

Help full for me

[@hathisinghfnc224]

Sir ji mere 233 colam he ,15000 Cr., Yese he eame 15000 Alng karna he or cr. Ye alng karna he eske liye aap help karna

[@ExcelWorldmis]

Share your email id, will share formula

[@ghumansaab2314]

Brother agar fraction (1/120) number alag krna ho to kaise kare gy?

[@ExcelWorldmis]

In that case you can use belo formula.
Before fraction
=LEFT(A2, FIND("/", A2) -1)
For After Fraction
=RIGHT(A2,LEN(A2)-FIND("/", A2))

[@ghumansaab2314]

@@ExcelWorldmis brother aap video bna sakte hai is topic pr

[@ExcelWorldmis]

@@ghumansaab2314 Sure... Will share within three days

[@ghumansaab2314]

@@ExcelWorldmis Thank you so much Brother 🙏
I will wait your video

[@ExcelWorldmis]

@@ghumansaab2314
Today we have uploaded video as per your request..(:
ua-cam.com/video/g0K7qHg33wU/v-deo.html

[@streeteverything3388]

Fabulous

[@ExcelWorldmis]

Thank You Sir

[@amitsahu819]

Bahut jyada accha

[@ExcelWorldmis]

Thankyou

[@marksibert6691]

Since I didn't hear English, I turned the sound off, but got the idea.

[@ExcelWorldmis]

Thank You so much for watching 🙏

[@WildlifeWonders_4K]

Y did u use 255 In formula ??

[@ExcelWorldmis]

255 is highest number for employee id....you can take 10, 20 whater number you want to split.

[@marksibert6691]

but my question would be, why'd anyone combine name and ID# in the same field?

[@ExcelWorldmis]

Sir this is only an example data...some time when we export data from l website or ERP we find combined data , like you will get pin, zip code with address.

[@techgalaxy100]

Video acha laga but concept samajh nahi aya. B3 ke baad &"0123456789" kyun lagaya ? Is ke peeche kya logic hai?

[@ExcelWorldmis]

Aap formula ko evaluate kr ke dekho, concept clear ho jayega.

[@techgalaxy100]

@@ExcelWorldmis Ok. I will try.

[@hemaprasath]

Came in very handy !! Great work

[@ExcelWorldmis]

Thank You

[@rajendrakumarbarik3968]

Nc bro

[@ExcelWorldmis]

Thank You

[@md.rashedrayhan5518]

Thanks

[@sureshprabhu5711]

thank u Sir nice please reply with firmula

[@ExcelWorldmis]

What formula required?

[@streeteverything3388]

Zabardast

[@ExcelWorldmis]

Thank You So much Sir

[@streeteverything3388]

Thank u bhiya

[@ExcelWorldmis]

🙏

[@sameersam8280]

Drag krne pr id nhi ari mere me Android mobile me

[@ExcelWorldmis]

Sir formula ek bar fir se check kijiye ho jayega.

[@harsinchh4342]

Sir,
how to seperate negative sign from no.
for eg.
A B C
-100 to - 100
600 600
-700 - 700
800 800
Please Reply.

[@ExcelWorldmis]

If you want several Only negative sign then you can use FIND function with LEN.

[@4kvibes42]

Bhai sare number ko Sum kese kare

[@ExcelWorldmis]

Share your email id..will send formula

[@zaid-e-mehfil2274]

Jab minimum le rhe hai to zero aana chahiye n.?
1 kyu aa rha?

[@ExcelWorldmis]

Sir minimum function number ki position k liye lgaya h na ki number k liye. Aap ek bar fir se try kijiye. Agr fir bhi koi issue ho to btana.

[@RajSharma-zn7zq]

Bhai itana jarurte nahi btane ke CtrlE kar do ho jayega

[@ExcelWorldmis]

Sir hr condition me ctrl e kam nhi krta or interview me formula se krna pdega.

[@anant2819]

This Formula only works when the number starts from "1", for any other number it does not work

[@ExcelWorldmis]

Sir number chahe kisi bhi digit se start ho formula sahi kam krega. .aap please ek bar fir se formula check kijiye.

[@amarjeetsingh8537]

Agar pahle numbers hai aur baad me text hai to formula bataoo na

[@ExcelWorldmis]

Sir if number length is same in data then you can use same formula.
You can change number of correctors as per your data. In this video I have put maximum number 255 in mid formula.

[@sangramgaikwad6670]

Ajay varma vs Ram deshmane to.... Ajay /Ram hona chahiye.

[@syedshafaqatali5357]

U can easily get numbers by using Right formula. Your process is very long

[@ExcelWorldmis]

Sir right formula tabhi kam krega jb number digit same hogi.

[@pronotoshnath8821]

Very hectic

[@vidyashautecuisine720]

Very confusing

[@royp7541]

Wasting your time bro. Highlight the cell, go to data, then go to from table/range this will bring power query editor. Then go to split column then go to by non digit to digit. Then go to close and load. This guy method is old and long.

[@ExcelWorldmis]

Thanks for the feedback....but if you use VBA then no use of your method also.
I have shared video for those who searching job for MIS.
If you are in interview then your choice and your method not help to get job. You have to answer as per interviewers requirements.

[@bipinmishra8699]

E