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

@ExcelWorldmis

3 жыл бұрын

Thank you so much for lovely feedback

Very informative video for learn. Thanks for sharing

Very useful information, thanks

Good video...thanks for sharing

Thank you so much ❤️❤️❤️

Thank you sit

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

@ExcelWorldmis

2 жыл бұрын

Thank You

Came in very handy !! Great work

@ExcelWorldmis

Жыл бұрын

Thank You

Very helpful

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

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

@ExcelWorldmis

3 жыл бұрын

Thank you....next video jald hi milega

thanks bro Good Luck

Thanx sir very simply & beautifully explained

@ExcelWorldmis

3 жыл бұрын

Thank You 😊

Help full for me

Great Video for me...thanks for sharing.

@ExcelWorldmis

3 жыл бұрын

Thanks

Very helpful, 👍👍Thanks Brother

@ExcelWorldmis

2 жыл бұрын

Thank you🙏

Thanks

Thank you so much success 💐

@ExcelWorldmis

2 жыл бұрын

Great thanks for watching

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

@ExcelWorldmis

2 жыл бұрын

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

Lovely bro thanks for this🙏

@ExcelWorldmis

Жыл бұрын

Thank You

Very well explain....keep it up.

@ExcelWorldmis

3 жыл бұрын

Thank You

Thank u bhiya

excellent thanks men

@ExcelWorldmis

2 жыл бұрын

Thank You

Keep going dear

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

Very useful

@ExcelWorldmis

2 жыл бұрын

Thank You Sir

very very nice bro...

@ExcelWorldmis

Жыл бұрын

Thank You Sir for watching

Great Dear ❤️❤️

@ExcelWorldmis

3 жыл бұрын

Thank you

Superb sir

@ExcelWorldmis

2 жыл бұрын

Thank you

nice 👍🏻👍🏻👍🏻

@ExcelWorldmis

3 жыл бұрын

Thank You

Good one

@ExcelWorldmis

Жыл бұрын

Thanks

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

@ExcelWorldmis

3 жыл бұрын

Share your email id will share with you.

@mohammedhammadahmed2168

3 жыл бұрын

@@ExcelWorldmis hammad.ashwaq@gmail.com thanks in advance

@ExcelWorldmis

3 жыл бұрын

Mail sent....Kindly check

Bahut jyada accha

@ExcelWorldmis

2 ай бұрын

Thankyou

Nc bro

@ExcelWorldmis

Жыл бұрын

Thank You

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

@ExcelWorldmis

Жыл бұрын

Thank You so much for watching 🙏

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

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

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

@ExcelWorldmis

2 жыл бұрын

Same as in video

Fabulous

@ExcelWorldmis

2 жыл бұрын

Thank You Sir

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

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

@ExcelWorldmis

3 жыл бұрын

Please share example

thank u Sir nice please reply with firmula

@ExcelWorldmis

3 жыл бұрын

What formula required?

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

@ExcelWorldmis

3 жыл бұрын

Kindly share your query in excel format on vaishnojyoti.enterprise@gmail.com

Zabardast

@ExcelWorldmis

2 жыл бұрын

Thank You So much Sir

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

@ExcelWorldmis

2 жыл бұрын

You can use both formula in first cell

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

@ExcelWorldmis

2 жыл бұрын

kzread.info/dash/bejne/Z46imJmPe9HAd5c.html Kindly watch this video...I hope your query has been resolved

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

@ExcelWorldmis

11 күн бұрын

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

Bhai agar cell main data without. Space ke ho to

@ExcelWorldmis

2 жыл бұрын

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

@PawanKumar-sx3ok

2 жыл бұрын

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

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

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.

Sir how can we do this work through vba code

@ExcelWorldmis

3 жыл бұрын

Share your email will send you vba code

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

2 жыл бұрын

Share your email id, will share formula

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

@ExcelWorldmis

3 жыл бұрын

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

@rohitchanda50

3 жыл бұрын

@@ExcelWorldmis sandifb2012@gmail.com

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

@ExcelWorldmis

3 жыл бұрын

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

3 жыл бұрын

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

@ExcelWorldmis

3 жыл бұрын

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

@ghumansaab2314

3 жыл бұрын

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

@ExcelWorldmis

3 жыл бұрын

@@ghumansaab2314 Today we have uploaded video as per your request..(: kzread.info/dash/bejne/mWR_mdOBl5aZp7g.html

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

Drag krne pr id nhi ari mere me Android mobile me

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

Very hectic

Bhai itana jarurte nahi btane ke CtrlE kar do ho jayega

Sir apna and ka simbal kyo lagaya hai please reply

@ExcelWorldmis

3 жыл бұрын

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

@CR_7717

3 жыл бұрын

Ok sir thank you

Y did u use 255 In formula ??

@ExcelWorldmis

2 жыл бұрын

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

Bhai sare number ko Sum kese kare

@ExcelWorldmis

2 жыл бұрын

Share your email id..will send formula

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

E

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

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.