Extract Numbers From Text in Excel

Thanks to Mr. Delphenium Aura for the Question.
How can we extract numbers from a text? For example👇
( ra46j8u9 y%a7da54v )"

in our everyday work life, we face many issues related to databases where we have a mixture of text, numbers, special characters, etc. and we have to extract numbers from that text or string.
So I am going to explain it today video with 2 examples. must watch this video till the end to know in detail.

Functions used
#LEN, #INDIRECT, #ROW, #MID, #IFERRO, #TEXTJOIN, #ISNUMBER, #LARGE, #SUM

Subscribe to YouTube & Follow on Dailymotion and Like Facebook Page👇

Download the Practice File here👇

[ramneeksharma]

Good thing about channel is it takes care of users who don't have 365 version

[creatorworld]

Wah Kya video banye hei. Ek dum badiya

[aisurjyasamantaray]

Thankyou for the video sir... One question ... Let's say there is a line....Harish has 150 rupees in 2 wallets. Can I use any function and extract only one number from this line. Like if I want to get 150 only or 2 only ... Then how to progress. Please rectify

[metauniverse]

Sir lookup me. 2 table array se related data formula kaise lagaye

[anil]

Please use flash function, than easy to use

[kartickchakraborty]

Wonderful Video. But Sir, I've some questions.

001) What if, I want the opposite. I mean to say, instead of numbers, I want text.

002) How to split names based on Capital Letter?

Suppose, you have 4 Names ("Raja", "SurajSingh", "SachineRameshTendulkar", Here, I want the First Name to be:- "Raja", "Suraj", "Sachine" and "Charles" respectively; the middle name to be:- "", "", "Ramesh" and "Henry William Petrick" respectively and the last name to be:- "", "Singh", "Tendulkar" and "Brown" respectively.

Is it possible using Excel Formulas?

[TheSuvankarKundu]

Thankyou so much sir.. But can you please show us how can we extract the text ..

[mr.psk.]

I have made a different approach for this problem.... how to share with you

[samikbanerjee]

Yeh jo video banaya hai apne yeh sirf Advanced minded logo ko samajh me ayega, STRICTLY NOT FOR EVERYONE, itna lengthy hai errors ayenge hi ayenge, Research, Work Hard aur Easy way laiye .

[aceracwer]

SIR PLEASE SHARE THE SEPERATE VIDEO TO EXTRACT TEXT FROM NUMBER

[halishahar]

how to get last 2 or 3 number? Can you help me pls

[MNS]

Can anyone write this command here, plz

[somendrashrimali]

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

[rajughimire]

sir I am from Nepal. I have a data with a colomn (max.9 digit) like
abcdef123
xyz8
123456789 in column A1, A2, A3.
I want to split these data into different colomn as LEN by right side.
The solution for A1 will be
B1=a, C1=b, D1=c, E1=d, F1=e, G1=f, H1=1, I1=2, J1=3... respectively.
The solution for A2 will be
J2=8, I2=z, H2=y, G2=x.
Sir I am trying different way but no success. Please let me guide.

[dikshitmunjal]

How to extract text in same example 🙄🙄🙄🙄

[storieswithtarasharma]

Although you have very good understanding but your way of teaching is not impressive