Using LEFT RIGHT & MID Functions in Excel
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Peaceful4You
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.
reply
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.
reply
Joy
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.
reply
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.
reply
Tony
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
reply
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
reply
Аркадик
Thanks for the so useful information, just these functions have a small problem with the date formats, so they convert it to the general format and deduce mistaken data ))
reply
Thanks for the so useful information, just these functions have a small problem with the date formats, so they convert it to the general format and deduce mistaken data ))
reply
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?
reply
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?
reply
Mr.YYS
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.
reply
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.
reply
Hamza
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
reply
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
reply
LEVANTATE
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?
reply
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?
reply
Ashley
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?
reply
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?
reply
Add a review, comment
Other channel videos
