How to use the LEFT, RIGHT and MID FUNCTIONS | Excel Tutorial
Channel: Burn to Learn
Date: 2023-04-19

Do you like our content? Buy us a cup of coffee!
https://ko-fi.com/burntolearn

Create amazing websites in just a few clicks with Squarespace
https://squarespace.syuh.net/burntolearn

The LEFT, RIGHT, and MID functions in Excel are commonly used to extract substrings from text strings. 

LEFT FUNCTION

Let's start with the LEFT function. The LEFT function allows you to extract a specified number of characters from the beginning of a text string. For example, if you have a column of addresses and you want to extract the state abbreviation. 

Write =LEFT(type the text or click the cell where the string is , comma. Then specify how many characters you want to extract 1,2,3 etc.,) Then close parenthesis and press enter.


To apply the formula to the entire column, position your mouse in the lower right corner of the cell till the cursor becomes a cross. Then double click and that’s it, the formula is applied to the entire column.

THE RIGHT FUNCTION

The RIGHT function is similar to the LEFT function, but it extracts characters from the end of a text string instead of the beginning.

For example, if you have a column of email addresses and you want to extract the .com .Write =RIGHT(the string or click on the cell where the string is then type a comma , now type the number of characters you want to extract, in this case 3) then hit Enter
 
Now apply the formula to the whole column if you want. Wow! Very useful right? But there is more

THE MID FUNCTION
The MID function allows you to extract a specified number of characters from the middle of a text string. 

For example if you  want to get the figure after the state code.
Write =MID( the text or click on the cell where the text is, comma, the extraction position where the string begins, in this case position 3, comma then the number of characters you want to extract. For this example 6 close parenthesis then hit enter. Now apply the formula to the whole column if you want.

Formulas and functions in excel are the easiest way to speed up and be more productive in your work.

0:00 - Intro
0:11 - How to use the Left Function
1:11 - How to use the Right Function
2:18 - How to use the Mid Function

Burn To Learn - T-Shirts
https://burntolearn.threadless.com/designs 

Visit our website http://www.burntolearn.com. to see all our tutorials.
Facebook: https://www.facebook.com/burtolearn/
Twitter: https://twitter.com/btltutorials
Instagram - https://www.instagram.com/btltutorials/
LinkedIn - https://www.linkedin.com/company/burntolearn.com/
Reddit - https://www.reddit.com/user/burn-to-learn/

 ------------------------               ---------------------------               ------------------------------ 

#Excel #Microsoft  #exceltips  #exceltutorial #leftrifhtandmid #excelfunctions