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.c...
(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

[@RishabhMishra-kn3fv]

Sir you are the best 👍💯 teacher ever i met on youTube

[@umairzahid3743]

sir baar baar dhaikny k baad aj smajh aya k agla space per kaisy pohnchy nested if k through. thanks sir

[@shaktisingh.g]

Really you are a best teacher on KZbin

[@Innozant]

Thanks ..Really means a lot to me

[@rahulrakshe1988]

very nice sir ... i learned lot of formulas from you

[@SAM-dq2qe]

Sir apne tough function ko asaan bana diya👍

[@sujankrishna5863]

It was really really a fantastic explanation and your effort is ultimate.....

[@Innozant]

Thanks Sujan..Happy learning ❤️🙏

[@surajmehta9232]

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]

Thanks Suraj for such a valuable and amazing feedback from yours.Really means a lot to me🙏❤️

[@virendrahardiya2797]

Wao sir, this is very automatically findings tricks, thank u so much sir ❤️💓🥳🎉👌👍🙏👏👏👏👏

[@KavitaDas-vx5lj]

My excel best teacher❤❤❤❤

[@sandeepaswal8944]

Sir आप Concept बहुत अच्छे से क्लियर करवाते हो | Keep teaching we will keep learning . Appreciated for your precious effort, God bless.

[@Innozant]

Thanks Sandeep Ji,Keep learning dear

[@ashishjha5123]

Great explanation sir, u are such a genius ❣️

[@Innozant]

Thanks Jha Ji .Keep Learning ❤️

[@Demon07291]

Me to fill flash ctrl+e se karta tha , abhi kuch naya shikha isko try karunga , best teacher🎉

[@Innozant]

👍

[@abhijeetbhattacharya1548]

You are really a good teacher. 🙏🙏🙏

[@Innozant]

Thanks dear

[@jaishrisaxena1083]

Bahut hi acha way hai samzane ka, jitni tareef karoo Kim hai

[@Innozant]

Thanks Jaishri

[@Innozant]

Thanks Jaishri,❤️

[@balamira297]

Sir Kya clarity hai apki teaching style mein!

[@Innozant]

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

[@dsraghav2882]

Really sir you brilliant teacher .

[@Innozant]

Thanks Raghav ji❤️🙏

[@AvinashSingh-im4oc]

Keep Teaching you are doing very well job thank you

[@niteshmandal5816]

Maza aa gye dekhke 🙏🙏

[@kapilkashyap7026]

Nice and very useful 👌 video. I love your innozant channel ❤. Pls keep it up in future.

[@Innozant]

Thanks Kapil Ji..Happy Learning dear ❤️❤️

[@subhashdhoke8439]

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]

Great...keep learning

[@shahzadsiddiqui5117]

speechless sir...!

[@dpak_sharma]

You are amazing sir 👌

[@srijithpillay3208]

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

[@SunnyNoobGamer]

Very Good Sir simply understand

[@Innozant]

Thanks Sunny ❤️👍

[@asifkhurshid9208]

Great Sir...So kind ..Great professor. thanks and regard.

[@aishwaryaambasta7013]

Useful function and effective video..

[@jaishrisaxena1083]

Very beautifully explained !

[@Innozant]

Thanks Jaishri,Must Watch Pivot Table Options video uploaded now,You may like it

[@sekharispassion]

Now I can extract text from a string using Left Mid and Right functions. Thank you.

[@Innozant]

Thanks Dear❤️❤️👍

[@mosadiq123]

You are really great sir

[@Innozant]

Thanks Dear..Happy Learning

[@RahulRoy-po9ct]

🙏 JAI HIND SIR🙏

[@preetivats4741]

❤❤❤❤

[@Altaf_Alam]

Good morning sir

[@Innozant]

Good Morning dear .happy learning

[@Thedeepanshu95]

I di the exact thing Nested Find before you taught it... Thank you sir Looking forward to your mail regarding the assessment...

[@Innozant]

👍👍🙏❤️which mail Anurag Ji?

[@Thedeepanshu95]

@@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 [e-mail]

[@Innozant]

Ok .For MIS opening,you need to clear our assessment test to get Interview reference

[@dhakafady774]

sir really , really , thanks to you sir

[@SethJewellersRaniganj]

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

[@sawaimalhi8439]

kiya baat hau guru aaap ki aj tak kabi nhe dekha tha ye chez

[@Innozant]

Thanks Dear...Seekhiye ache se concept ..

[@sawaimalhi8439]

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

[@gauravbhatia7987]

Thnq sir so much

[@sanjayrathore8599]

Sir jese apne 1+ karkr next space par puch gye the +1 ki jagah +2 karke uske bhi aglr space par puch sakte he

[@vickyaswal4582]

Thank you sir

[@spatelprinting496]

Thank You

[@PradeepKumar-yp3tc]

I have learnt a lot from you sir, I wish I could afford your fee.

[@Innozant]

Thanks dear...No issue,You may learn from Innozant channel,Complete course is there..Happy learning

[@PradeepKumar-yp3tc]

@@Innozant thank you so much sir

[@sadashivkage3133]

TQ...SIR....🙏🙏

[@shaktisingh.g]

Sir please make ai use in excel related videos

[@dhakafady774]

wow sir thanks

[@2minuteknowledge855]

good sir ji

[@jogendrakumar3356]

Nice sir!

[@bhoopendraraghav9781]

Very nice

[@uniquemobiletipstricks7714]

इसमें delimiter है तो text to column से भी तो ये हो सकता हैं columns extra ले लेंगे

[@dhakafady774]

sir love you , sir

[@MohanKumar-uk1gj]

Sir wonderful

[@Innozant]

Thanks Mohan

[@MohanKumar-uk1gj]

@@InnozantSirji kya aap hame SQL queries sikha sakte ho

[@Innozant]

haan aayega videos sql ke bhi

[@houseofdrama7572]

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!

[@pawanwakale8801]

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

[@PawanKumar-sx3ok]

Thanku sir

[@Innozant]

Thanks Pawan Ji❤️

[@motivationalarunsingh]

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

[@anshulpathak1434]

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

[@adiluddin5974]

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

[@exceltipsandtricksbyankitk4546]

We can use =right (a22),Len(a22)-find(" ",a22,9)) and press enter

[@anantahembram4989]

Wow! 👍👍

[@Innozant]

Thanks Ananta,We welcome you to experience the taste of success witb Innozant-Seed of Success.

[@somnathmukherjee6687]

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]

Sir, i mean -1

[@fermion4945]

Replace se kr lo . =REPLACE(old_text,1,FIND(" ",within_text,FIND(" ",within_text)+1),"")

[@dhakafady774]

"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

[@mohitsharma-ym3km]

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]

Mohit Ji Text to column or flash fill is one time solution only ..It is not a permanent solution as formula do.

[@KunalSingh-oy1ny]

Sir is it compulsory to use len() funcn while using right funcn or can we find it only by right and find funcn.

[@Innozant]

yes we need to use len as right function extract data from right to left

[@KunalSingh-oy1ny]

@@Innozant and sir why not we use len in left funcn

[@Innozant]

there is no neer to use len thete az it extracts text from left to right

[@AiIsfuture-tj4os]

Sir please mid formula ka use karke mid name ko extract kariye please sir

[@fermion4945]

Iska next video dekh lo

[@EqbalAKhan]

sir, how to find & delete a line inserted in a cell with the help of Alt+Enter in excel. Kindly respond

[@Innozant]

Help of Atl enter? Alt enter is used to insert multiple line in a single cell

[@EqbalAKhan]

@@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.

[@Taris376]

Hello sir After evaluating formula with F9 How we can get actual formula again

[@Innozant]

Undo-ctrl z

[@Taris376]

@@Innozant maine kiya tha but wo apni actual form me nhi aya To fir copy v nhi ho raha tha formula

[@neerajrai9209]

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]

Formula use Karna chahte Hain ya tool..? Tool se to bht simple hai text to column ya flash fill use kr lijiye

[@neerajrai9209]

@@Innozant sir Maine sab try kar liya ha tavi tho apko approch kiya ha

[@omsingh9100]

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.

[@anshulpathak1434]

Agar replace se Karuna ko kese nikalu ga sir

[@muzaffarali3399]

Sir एक वीडियो बड़ी संख्या पर भी बना दो 50000/60000=60000 40000/20000=40000

[@hemchandpawar459]

Sir Gmail I'd se example krwaun please 🙏

[@ChandanDas-wl2uk]

🙏🙏🙏

[@ChandanDas-wl2uk]

Sir,, can I solve this problem with the formula of substitute...??

[@MohanKumar-uk1gj]

Sirji how to find the 3rd space in the text I tried its giving error.. pls help

[@Innozant]

launch video. wp traditional method se nhi hoga

[@MohanKumar-uk1gj]

@@Innozant hi dilipji any update on this topic

[@omparkashpatlan]

Sir, how to Converting a number (1,2,3) to a string (one, two, three)

[@Innozant]

Om soon coming with this video with explanation step by step🙏🙂❤️

[@amitpyasi2819]

Sir Please upload video math function

[@PritamPaul717]

❤🙂👍

[@awanishanurag1763]

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!!

[@narendranawgire1549]

1) Neha Iyju (IV/A) how to separate in exel

[@vinaythakur1150]

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]

iferror lagske null pass kr dein..jahan ek hi name hogs wo blank kr dega

[@vinaythakur1150]

@@Innozant sir par hme blank nhi chahiye wo single name bhi to chahiye as a first name.

[@Innozant]

single name to aayega hi ,iferror to bus jahan error aayega uske jagah null

[@vinaythakur1150]

@@Innozant sir jaha single name है. Whi to error aa raha hai. Send me ur WhatsApp no. I send pic. File.

[@navanitmaiti7230]

Sir apne 1 hi questions solve kiya..phir ek hi click me baki automatically kaise solve ho gaya??

[@Innozant]

Matlab?query phirse puchiye dear

[@Livevirals]

Bro formula ek hi cell me lgta hai baki drag down krte h to automatically sb solve ho jate h

[@vishaltamta6504]

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]

Excel maharaj series dekhiye aap..mil jayega solution aapko

[@Shorthandwithsunitainm.v.3]

I am unable to find initial of last name. I need initial of first,middle and last name.

[@deepakchauhan4974]

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]

Will make video for the same in text maharaj..usimg left substitute and iferror we can easily do this prob

[@deepakchauhan4974]

@@Innozant will wait for this

[@SushilKumar-hi9wt]

Excel sheet ka link de Diya kro ji

[@Innozant]

Diya gya hai maste link

[@anupmanna178]

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]

@innozantofficial telegram id par share kren query

[@aafreenaafreenshaikh2560]

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

[@true-fy9pk]

Address main se pin code kaise alag Karen

[@Innozant]

Address Ka for Kaisa hai wo bataiye

[@Thedeepanshu95]

-?????? use karke kyunki pin code hamesha Dash(-) ke saath use hota hai , you can give it a try

[@pranjalkastwar8731]

NESTED FIND SAMAJ NHI Aaya

[@mariantonys]

aap ke voice echo maar raha hai

[@AlimKhan-bl5sh]

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]

👍

[@RajeshKumar-yt5mp]

THANKYOU SIR

[@Innozant]

Thanks Rajesh ji

[@dhakafady774]

"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

[@dhakafady774]

"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

[@dhakafady774]

"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

[@dhakafady774]

"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

[@dhakafady774]

"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

[@dhakafady774]

"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

[@dhakafady774]

"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

[@dhakafady774]

"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