Extract Number and Text from Mix Data in Excel

In this video you learn "How to extract Emp. ID from text (Mix Data) in Excel using a single formula.This is one of the very common situation which almost every user must have faced in his/her life. Either they get data from other team members in such a way where the mix data and they want only numbers or text.
We all know there is no particular in-built function in Excel which allows extracting number or text from mix data.

We've good way to resolve this type of problems with using a single formula only. After watching this tutorial, you will become an expert of extracting number or text from mix data).

We have created this tutorial using following features:
1. FIND FUNCTION
2. MIN FUNCTION
3. SUBSTITUTE FUNCTION
4. MID FUNCTION

In case of any simple or complicated "EXCEL" QUERY, You can join our WhatsApp Group for instant solution @
Refer this link to join group:-

[lakhbirsingh]

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

[deppuraghav]

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

[karmasinggh]

Very informative video for learn. Thanks for sharing

[arnav.borah]

It really awesome. Thank you so much. Amazing

[KaranSharma-hzrr]

Great Video for me...thanks for sharing.

[arnabghosh]

Thanx sir very simply & beautifully explained

[saleembaig]

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

[enlighteningbrain]

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

[marksibert]

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

[kamlesharya]

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

[VijaySharma-dolj]

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

[nayanparmar]

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

[mohammedhammadahmed]

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

[krishnabhattarai]

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

[msamidireddy]

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