Using LEFT RIGHT & MID Functions in Excel

[@cierraaaaaaa]

Thank you so much! The mid formula is what I needed to use!

[@lorcanrodgers8575]

How would I do the mid function if I have different lengths of characters? Say June, September and March

[@fitting9132]

In this case potentially use “Text to columns” with delimiter. Hope it helps

[@farhan_aylee]

For this, you can use the Find function along with the Mid function.

[@banishclock17]

Thank you for explaining this step by step!

[@hamzamudassir3656]

Thank you so so soo much tomorrow is my ICT test and I’m a late joiner so I haven’t attended any lecture this really helped me hopefully I get good grades

[@HafsaAnsari-em6zd]

🎉

[@Pqwer]

good luck

[@peaceful4you408]

I just finally barely passed an excel class that emphasized this MID function. I go to Cornell University so of course they are going to make the classes extremely difficult. The MID function within itself is not hard to learn at all but Cornell added an advanced skill to the MID function that made it extremely difficult to understand. What they did was have students conduct mathematical calculations within the MID function to allow it to add, subtract, multiply and divide within the second argument and then reference that calculation to other cells and even other worksheets. That class was no joke. The class is called fundamentals of spreadsheets at Cornell. Fundamentals my ass.

[@jamesgraham9647]

That's some advance shit

[@peaceful4you408]

@@jamesgraham9647 yea

[@estherschuckard4192]

Thanks!

[@techteachersandstudents]

Thank you for watching! I appreciate your support!

[@muhammadfarooq5925]

really appreciate it, this video helps me to solve my issue. thanks

[@paveldorozkin123]

Super.It's the best tutorial what i ever saw about excel.

[@Cris-hk4cn]

Your presentation was on point. Great job!!! Thanks

[@Iam_Chirag]

The Video was Useful ❤️😊

[@jaydenperry846]

this is so usefull and i have started my own channel and would love some support and this is the person to listen to

[@yonasmisganaw6023]

Thanks bro it is the easies and fastest way to split the text what ever that is and keep it up

[@alexandercastillo8887]

Oh my god, i don't speak english very well, but i understand everything. You are the best explaining

[@kidsmemorylane6804]

great example, and clear explanation. Thank you sir.

[@at9124]

Well explained, many thanks.

[@ham-han]

Thanks Sir!! Very helpful

[@fantasyrosesyt873]

Thank you for this! Appreciate it!

[@dheerajsinghbisht2759]

Thanks for the video, great and easy to understand

[@kathleencrisp1]

Thank you, this was very helpful. Stay well. All the best. Appreciative Excel beginner.

[@weixuhe9230]

Thank you！It‘s so helpful

[@defnotnicol]

Thank you!! This is so helpful

[@nyeletisebanda5616]

So helpful ..Thank you sir...

[@ЮлияКоробейникова-э6ф]

Great example and explanation! thank you!

[@sabasumbad8308]

Thank u for making such useful n easy to understand videos ,i have recently started watching ur videos n i just love ur explanation pls upload more videos n can u pks also make ms power bi videos

[@nathaliemart8409]

Great video 👍

[@vaibhavandhale8616]

Thanks for sharing information

[@sankettrama1472]

It was very helpful thanks

[@asimali5820]

Thank you for making such an informative turorial!

[@ZaiqaLahoreKa]

Very informative

[@tinhocngoaingu368]

USEFUL, TKS TEACHER.

[@hokaidoshin8626]

Thanks for the mid function

[@mitegirl2559]

excellent can clearly understand

[@MyBobo1980]

Great videos !

[@arunmishra9162]

Easy and working.

[@ashleygoldman3299]

Very helpful, but what if I want to get the string until a fund a : or a comma or another symbol? there is a way to do that?

[@josephselwan1652]

it was useful thanks!

[@ruscoebrobbey24]

good job Sir

[@זיואהרון-ע2ר]

very helpfull !

[@saiwanjabary5646]

Thnks alot 🥰🥰

[@Joy-qi9yb]

Straightforward video thanks! But I am stuck with the more complex use of Mid function. Let's said we have a column for the states and we want to retrieve Ohio(OH) from the address so I assume we use the Mid and Find function but how do we retrieve just the Ohio(OH) part in such a long text format.

[@muthusamyrs6356]

=MID(C2,FIND("(",C2)+1,2) - This is the formula to extract states from address

[@afreenbaba1421]

Thanks

[@emad2]

Fantastic

[@santmun2008]

Thank you sir ji

[@wenjagameplay]

Golden!

[@arafathossain3079]

Would you please give the practice file. The download link you already share is not working currently. Thank you

[@techteachersandstudents]

It seems to be working for me. Please try copying and then pasting the link into your browser. Sometimes that works better than clicking the link. Thanks for watching.

[@tonyburgess8727]

Good tutorial - but the problem I have often is the input data is not always consistent -sometimes the phone is formatted as xxx-xxx-xxxx, or the zip code is xxxxx-xxxx. Maybe a follow up tutorial at some point on how to address these discrepancies. I did enjoy the video. Thanks

[@pattyyeomans6334]

you ignored a basic "rule" of Excel: it is important to enter data in cells by the same format! The only way I know is to go back after using the Left, mid, right function and correct the source info in the proper format. Once it is corrected, the extracted information will also display correctly.

[@bunthoeurnofficial]

so good

[@EXCELMASTER-Wiseoption]

GOOD CONTENT

[@charlotteituralde5409]

Thank you

[@chowdhurysunzidmahbub79]

if there is any blank cell in Column D,how it will work in Auto fill in column F???

[@rajeevgosavi4514]

Quite helpful. How do you build mid function when no. of charecters in a middle value varies from row to row.

[@purbitabiswas7373]

Write formulae individually for cells that vary in characters

[@catherineismyname6068]

These helpful

[@ruhulaminfuad2381]

I can't download this file. Can I get the real file for practice?

[@granand]

The practice file link doen't seem to work for me. Thank you a lot brother for knowledge. Appreciate your help

[@levantateyora9317]

Sr how about if I have a sheet and it has words and numbers but I want excel to extract just the number on one side, how can I do this?

[@teralore]

Would Flash Fill be able to do this? Atleast for this example.

[@andrewau1993]

Kindly tell me what you use to record screen

[@saleembaig5104]

In my case zip code not the same 5 ch. some with more the 5 ch. and less the 5. how can I extract

[@xiaoluliu8001]

thanks!

[@ahamedfazeer6289]

Thanks a lot

[@prashanthkoundinya8385]

How to write a formula where it excludes the parenthesis on the left?

[@barackuse]

This is great, however the issue I have is that there is a "." following each month, IE June., I don't want the period to show up. How would you remove that?

[@Pa1-369]

What if we want to retrieve the Date Number from the given date?

[@zaksav]

what if in the area code i wanted it to appear without parenthesis ?

[@mr.yyschn898]

Excuse, may i ask Teacher , What's the function to separate this, Example : World Health Organization separate to WHO. thanks in advance for your answer.

[@justinchong4737]

Not sure if this is the best way but I know it’ll work…but you can use the spaces as a delimiter (google delimiter excel) to split the worlds into three columns. From there, you can use the concatenation function and the LEFT function to join the first letter of each word in each column together. Cheers!

[@rohanbhondekar2096]

Can we use both RIGHT and LEFT formula together?

[@antodedater3359]

Thanks you very much for the video. Still remains a question. Anyone knows how to use the left function for a number, without taking the zero as a number. For instance, LEFT(0,55) gives 0 as output, while I want to ignore the 0, and only get the 5. Anyone can help me?

[@RichardNievesNY]

How you extract the State? Since it's different lengths

[@gayleskye]

Only in this video that I understand that formula

[@iamshrija]

best way is to do Alt+A+E then extract from , or space.......... so easy...

[@CambodianTutorials]

thanks

[@TostEZ28]

What if there was a different amount of characters rather than them all being the same

[@DhruvPatel-pe1ns]

Use *Find("_",Char.)* function in all these conditions.

[@misheck8933]

How do you extract the state?

[@PritomAhad]

Imagine i have two words how do i make a four letter code that is taking three letters frm first word nd one frm another

[@akhilv-y5u]

How to extract address without pincode is what i am looking at? Can you please help?

[@Coolguy_5]

❤❤❤ ict

[@Artformatics]

Why not use find function and make this formula dynamic rather than counting the position of the desired text.

[@srinuvericharla1582]

Sir Please show me date ....? About 2 nd culom...

[@RA-kd3ne]

You did Everything manually..instead of counting, can you show find and len function using mid function

[@cbdofficial4080]

good

[@stardomee]

this data manipulation requires uniform data

[@kesavamoorthyaudit5547]

Sir please say formula (india private limited-12345) how to split company name only like india private limited

[@JmS2687]

⭐️⭐️⭐️⭐️⭐️

[@avikbhattacharya8287]

আমাদের ইন্ডিয়াতে এতো straightforward data আসে না ভাই

[@shambhavibhagat1469]

Hi Sir, NEFT-HSBCN23212775696-NATIONAL INSURANCE CO LTD. How can I find out HSBCN23212775696 from this, which formula will I use? Please help.

[@realifyalfred]

This was so helpful. Thanks so much I appreciate it.

[@fitting9132]

Thanks!

[@enochjnr6341]

Thank you

[@tahrim.ononno]

Thanks

[@mrrazi8780]

thanks