 The left, right, and mid functions in Excel are commonly used to extract substrings from text string. 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, right, equal sign, left, open parentheses, type the text, or click the cell where the string is, comma, then specify how many characters you want to extract, one, two, three, etc., then close parentheses and press enter. Help! Please fire up my inspiration by buying me a coffee. See the link in the description below. 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 is similar to the left function, but it extracts characters from the end of a text string instead of the beginning. For example, right, equal sign, right, open parentheses, 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, close parentheses, then hit enter. Now apply the formula to the whole column if you want. Wow! Very useful, right? Forget the nightmare of creating or renovating your website. Just a few days ago, we found ourselves in the need to renovate our site. Squarespace made it easy with dozens of customizable templates that allow users to make their website their own. Squarespace makes it a worry-free option for users. In a matter of minutes, we renewed our site in an easy and simple way. We encourage you to visit our friends at Squarespace. The link is in the description below. 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 equal sign, mid, open parentheses, the text or click on the cell where the text is, comma, the extraction position where the string begins, in this case, position three, comma, then the number of characters you want to extract. For this example, six, close parentheses, 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. Remember to subscribe to our Burn to Learn channel.