Advanced Text Function in Excel | Best use of Right and Replace Function in Excel in Hindi
Advanced Text Function in Excel | Best use of Right and Replace Function in Excel in Hindi
1. How to extract last name using Right Function in Excel
2. Using Replace function in excel to extract last name
3. Best use of Advanced Text function in excel in hindi
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
(Playlist Folder-Basic Excel-TextAdvanced2.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#textfunctin #exceltextfunction #innozant #Exceltutorial #Exceltricks
Пікірлер: 161
Great Sir...So kind ..Great professor. thanks and regard.
Useful function and effective video..
Keep Teaching you are doing very well job thank you
very nice sir ... i learned lot of formulas from you
speechless sir...!
Sir you are the best 👍💯 teacher ever i met on youTube
Sir apne tough function ko asaan bana diya👍
sir really , really , thanks to you sir
Very beautifully explained !
@Innozant
4 жыл бұрын
Thanks Jaishri,Must Watch Pivot Table Options video uploaded now,You may like it
You are amazing sir 👌
It was really really a fantastic explanation and your effort is ultimate.....
@Innozant
3 жыл бұрын
Thanks Sujan..Happy learning ❤️🙏
Wao sir, this is very automatically findings tricks, thank u so much sir ❤️💓🥳🎉👌👍🙏👏👏👏👏
My excel best teacher❤❤❤❤
Me to fill flash ctrl+e se karta tha , abhi kuch naya shikha isko try karunga , best teacher🎉
@Innozant
Жыл бұрын
👍
Thank you sir
Nice and very useful 👌 video. I love your innozant channel ❤. Pls keep it up in future.
@Innozant
3 жыл бұрын
Thanks Kapil Ji..Happy Learning dear ❤️❤️
Thnq sir so much
Nice sir!
Very Good Sir simply understand
@Innozant
3 жыл бұрын
Thanks Sunny ❤️👍
You are really a good teacher. 🙏🙏🙏
@Innozant
2 жыл бұрын
Thanks dear
Thank You
wow sir thanks
Really you are a best teacher on KZread
@Innozant
10 ай бұрын
Thanks ..Really means a lot to me
Great explanation sir, u are such a genius ❣️
@Innozant
Жыл бұрын
Thanks Jha Ji .Keep Learning ❤️
You are really great sir
@Innozant
3 жыл бұрын
Thanks Dear..Happy Learning
TQ...SIR....🙏🙏
Now I can extract text from a string using Left Mid and Right functions. Thank you.
@Innozant
3 жыл бұрын
Thanks Dear❤️❤️👍
Really sir you brilliant teacher .
@Innozant
3 жыл бұрын
Thanks Raghav ji❤️🙏
Very nice
Sir, jitna mai apke videos dekhta hu shayad hi koi dekhta hoga, jab bhi free hota hu dekh leta hu.. aur maine ek application bhi bna liya with the help of advanced excel. Aur pura sukh kar hi chodunga...thank you.
@Innozant
4 ай бұрын
Great...keep learning
everytime I learn something in class and revise the entire course it seems easy😂😂😂 but when I open this channel...it seems there is a lot and its a vast course🙏🙏...so basically I m learning the basic while paying and learning the actual thing here witjout paying a single penny....you are doing a great job sir...❤️❤️❤️
@Innozant
3 жыл бұрын
Thanks Suraj for such a valuable and amazing feedback from yours.Really means a lot to me🙏❤️
Sir आप Concept बहुत अच्छे से क्लियर करवाते हो | Keep teaching we will keep learning . Appreciated for your precious effort, God bless.
@Innozant
4 жыл бұрын
Thanks Sandeep Ji,Keep learning dear
Wow! 👍👍
@Innozant
3 жыл бұрын
Thanks Ananta,We welcome you to experience the taste of success witb Innozant-Seed of Success.
THANKYOU SIR
@Innozant
2 жыл бұрын
Thanks Rajesh ji
sir love you , sir
🙏 JAI HIND SIR🙏
good sir ji
Bahut hi acha way hai samzane ka, jitni tareef karoo Kim hai
@Innozant
4 жыл бұрын
Thanks Jaishri
@Innozant
4 жыл бұрын
Thanks Jaishri,❤️
Thanku sir
@Innozant
2 жыл бұрын
Thanks Pawan Ji❤️
Sir, Great explanation... please guide if there is mixture of words like a table contains First and Last name, First Middle and Last name or First Middle1 Middle2 and Last name...how to extract last name from such table
Sir jese apne 1+ karkr next space par puch gye the +1 ki jagah +2 karke uske bhi aglr space par puch sakte he
❤❤❤❤
Good morning sir
@Innozant
Жыл бұрын
Good Morning dear .happy learning
thank to you for your support so that we can learn more about excel. one question which trouble, how find duplicate and solve like this data - contact no . 100 rows in a sheet, one, two ,three mobile no in sequent may be repeat one mobile no in three time
kiya baat hau guru aaap ki aj tak kabi nhe dekha tha ye chez
@Innozant
3 жыл бұрын
Thanks Dear...Seekhiye ache se concept ..
@sawaimalhi8439
3 жыл бұрын
Abi b confused hoon m dourbra try karunga kiyn k use tu kr laita hoon aaap k le lecture ko par meri life m ye use nhe hota hai ..Bar bar bhool jata hoon ...Phir muje dil say ye he fell hota hai abi tak kuch nhe sekha bar bar nirasha ah jate hai q sir
Sir wonderful
@Innozant
3 жыл бұрын
Thanks Mohan
@MohanKumar-uk1gj
3 жыл бұрын
@@InnozantSirji kya aap hame SQL queries sikha sakte ho
@Innozant
3 жыл бұрын
haan aayega videos sql ke bhi
❤🙂👍
I di the exact thing Nested Find before you taught it... Thank you sir Looking forward to your mail regarding the assessment...
@Innozant
3 жыл бұрын
👍👍🙏❤️which mail Anurag Ji?
@Thedeepanshu95
3 жыл бұрын
@@Innozant you told me I'll tell if something comes up for MIS executive post... When I told you I know advanced excel, SQL, Tableau but couldn't find job...as I'm fresher for 2 years... My mail ID is anurag14pro@gmail.com
@Innozant
3 жыл бұрын
Ok .For MIS opening,you need to clear our assessment test to get Interview reference
Sir Kya clarity hai apki teaching style mein!
@Innozant
2 жыл бұрын
Thanks Mira aapke itne pyare aur valuable feedback ke liye mBht mayne rakhta hai merr liye ye words..Main koshish karunga ap sabhi ke life me kuch value yadi add kar sakun wahi hai mere liye success hona.❤️❤️❤️ Thanks for being part of Innozant Family
Sir please make ai use in excel related videos
इसमें delimiter है तो text to column से भी तो ये हो सकता हैं columns extra ले लेंगे
Sir when i use search formula 3 time for 3 space its showing me only 2 time space value, if possible can you please response for understanding (Bagels, Muffins, and Breakfast) this is the format!
🙏🙏🙏
@ChandanDas-wl2uk
2 жыл бұрын
Sir,, can I solve this problem with the formula of substitute...??
Sir agar left ka nikal na h to replace ke formula me kya 2 change ho ga sir a nahi raha sir please help me
Agar replace se Karuna ko kese nikalu ga sir
I have learnt a lot from you sir, I wish I could afford your fee.
@Innozant
2 жыл бұрын
Thanks dear...No issue,You may learn from Innozant channel,Complete course is there..Happy learning
@PradeepKumar-yp3tc
2 жыл бұрын
@@Innozant thank you so much sir
SIR when we are doing copying its very east but when we are trying on our own it difficult , Practise practise and practise,,,, he continuous practise se aa jayena na i am preparing for MIS ,in our organisation opening are coming continous . want to crack this time anyhow
Sir, I have 3 underscores in my data, m unable to extract the right with right function..please help..My data is as below, Acct_No_Project_123456789
Sir chahte Hain ek hi cell mein Text likhe cell ka size wahi rahe aur Text size chota hoke usi me dike pura Text(text jahe jitna likhe ) thank you
Sir is it compulsory to use len() funcn while using right funcn or can we find it only by right and find funcn.
@Innozant
3 жыл бұрын
yes we need to use len as right function extract data from right to left
@KunalSingh-oy1ny
3 жыл бұрын
@@Innozant and sir why not we use len in left funcn
@Innozant
3 жыл бұрын
there is no neer to use len thete az it extracts text from left to right
1) Neha Iyju (IV/A) how to separate in exel
We can use =right (a22),Len(a22)-find(" ",a22,9)) and press enter
Sir please mid formula ka use karke mid name ko extract kariye please sir
@fermion4945
3 ай бұрын
Iska next video dekh lo
sir, how to find & delete a line inserted in a cell with the help of Alt+Enter in excel. Kindly respond
@Innozant
2 жыл бұрын
Help of Atl enter? Alt enter is used to insert multiple line in a single cell
@EqbalAKhan
2 жыл бұрын
@@Innozant Yes! i have large data having some extra multiple lines & i want to delete all of these extra lines, because i am facing much trouble to handle it.
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
When we have text to column method so why we are using this method ?? Is it important in real job or we are just learning this method ???
@Innozant
3 жыл бұрын
Mohit Ji Text to column or flash fill is one time solution only ..It is not a permanent solution as formula do.
Sir, how to Converting a number (1,2,3) to a string (one, two, three)
@Innozant
3 жыл бұрын
Om soon coming with this video with explanation step by step🙏🙂❤️
@amitpyasi2819
3 жыл бұрын
Sir Please upload video math function
Hello sir After evaluating formula with F9 How we can get actual formula again
@Innozant
Жыл бұрын
Undo-ctrl z
@SachinKumar-zz9dq
Жыл бұрын
@@Innozant maine kiya tha but wo apni actual form me nhi aya To fir copy v nhi ho raha tha formula
Sir Gmail I'd se example krwaun please 🙏
What short key is use to check the value of any फार्मूला?
@Innozant
Жыл бұрын
F9 is use to evaluate
@omsingh9100
Жыл бұрын
@@Innozant and for again come on formula what short key is use boss.
Sir एक वीडियो बड़ी संख्या पर भी बना दो 50000/60000=60000 40000/20000=40000
Sirji how to find the 3rd space in the text I tried its giving error.. pls help
@Innozant
3 жыл бұрын
launch video. wp traditional method se nhi hoga
@MohanKumar-uk1gj
3 жыл бұрын
@@Innozant hi dilipji any update on this topic
Dear Sir, suppose my name Anish Kumar Yadav , to find yadav =right(old txt,find(" ",oldtext)+1) here also bring me the last name, i am a learner, still now i learn every thing from you , is this formula right
@somnathmukherjee6687
9 ай бұрын
Sir, i mean -1
@fermion4945
3 ай бұрын
Replace se kr lo . =REPLACE(old_text,1,FIND(" ",within_text,FIND(" ",within_text)+1),"")
I am unable to find initial of last name. I need initial of first,middle and last name.
Hi sir pl suggest if We have date Like this so how can find the output. Data The cost USD Is 100 His Score is 79 Item core is 14258 Ticket number is 1245 We just want Numeric part and Text part both should be individual row and columns.
@Innozant
3 жыл бұрын
Formula use Karna chahte Hain ya tool..? Tool se to bht simple hai text to column ya flash fill use kr lijiye
@neerajrai9209
3 жыл бұрын
@@Innozant sir Maine sab try kar liya ha tavi tho apko approch kiya ha
sir kisi ka sir name "anshu ram" use condition m y formula m error aa rha, Y only us condition m le rha jab kisi ka last name "ansu aman sood" ho tab y last wala le rha h. mujhe aisa chaiye ki agar kisi ka name eg. rahul kumar, ya rahul kumar roy us condition m mujhe last name chaye bas
@Innozant
2 жыл бұрын
Excel maharaj series dekhiye aap..mil jayega solution aapko
Excel sheet ka link de Diya kro ji
@Innozant
2 ай бұрын
Diya gya hai maste link
Address main se pin code kaise alag Karen
@Innozant
3 жыл бұрын
Address Ka for Kaisa hai wo bataiye
@Thedeepanshu95
3 жыл бұрын
-?????? use karke kyunki pin code hamesha Dash(-) ke saath use hota hai , you can give it a try
Sir ,jab output basically Lana hai minus plus karke hin, toh fir Left Right Mid in teeno ka kya sense hai mujhe nahi samajh aa raha hai!! Sorry sir aapke itna acchhe se mehnat se samjhane ke baad bhi mujhe fir se aapse puchna pad raha hai !!
@Innozant
Жыл бұрын
Phirse dekhiye ek baar video dear..aayega samajh..
@awanishanurag1763
Жыл бұрын
@@Innozant sir mera kehne ka matlab hai ki ek certain length mei se ek certain length ko subtract hi toh hum kar rahe hain aur jo bach gaya wo humara output hai , fir isme Mid kya role play kar raha hai !koshish karta hun fir se samajhne ki thanks!!
Sir apne 1 hi questions solve kiya..phir ek hi click me baki automatically kaise solve ho gaya??
@Innozant
2 жыл бұрын
Matlab?query phirse puchiye dear
@Livevirals
2 жыл бұрын
Bro formula ek hi cell me lgta hai baki drag down krte h to automatically sb solve ho jate h
Agar sir hamare pass 10 name hai , jisme ki koi 2 words or koi 3 words ka hai or hame right name sirf nikalana hai , to kaise nikalenge
@Innozant
3 жыл бұрын
Will make video for the same in text maharaj..usimg left substitute and iferror we can easily do this prob
@deepakchauhan4974
3 жыл бұрын
@@Innozant will wait for this
aap ke voice echo maar raha hai
Sir please isko explain ki ji ye...isko kaise kare...Pahle item details then item code Example 39258 calc = 0001 39258 calc red = 0002 Lekin order aaya hai 39258 red 120 chk calc 39258 regular calc In this case how to find the exact item code In order details
@Innozant
2 жыл бұрын
@innozantofficial telegram id par share kren query
8 se 10 barr video ko dekha tab jaake samjh aya hai mere k find ko nested ku kar rahe the aap... Apne asal me kara kya hai.. Jo start number hai na uski jagah pe apne ek or find chala diya +1 add karke jisse k wo doosre space par pahuch gaya..ab jaake samjh aya hai😂😂
@Innozant
2 ай бұрын
👍
Sir I have a doubt. मेरे पास एक लिस्ट है. Names की. जिसमें से मुझे first and last name अलग करने है. Left and find formula लगाने के बाद मेरा first name to अलग हुआ. Magar जहाँ - 2 list में only ek hi name है. वहाँ error show हो रही है. तो मुझे फिर अब कौन सा formula lagana hoga. Kindly send me syntax of formula.
@Innozant
3 жыл бұрын
iferror lagske null pass kr dein..jahan ek hi name hogs wo blank kr dega
@vinaythakur1150
3 жыл бұрын
@@Innozant sir par hme blank nhi chahiye wo single name bhi to chahiye as a first name.
@Innozant
3 жыл бұрын
single name to aayega hi ,iferror to bus jahan error aayega uske jagah null
@vinaythakur1150
3 жыл бұрын
@@Innozant sir jaha single name है. Whi to error aa raha hai. Send me ur WhatsApp no. I send pic. File.
I have a query regarding replace formula that is- I use replace formula as below: 1000-33 replaced with 1000-033 1000-1 replaced with 1000-01 But want 1000-1 replaced with 1000-001 So I want to know how to use one replace formula or another adding formula which make the series of the Numbers
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name please sir help me