Updated: Aug 24, 2021
Today we will be learning a simple and helpful String Function. The Left, Right and Mid Functions. These functions enable us to select the number of values we wish to find. In our spreadsheet example, we will be sending mails to Elon Musk, Bill Gate, Jeff Bezos, Larry Page and Tim Cook. We will also include added information of their Register Mail, Contact Number and Address. Without further ado, let us get started.
We will also show you how to convert your LEFT function into an API at the end of the video.
Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download
How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ
How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ
Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj/
First, let us learn the LEFT function by counting the first 2 values from the Registered Mail to our Product Code. Select Cell F4, type in equal, LEFT, open parentheses. Select Cell B4, comma, space and type in 2. Close parentheses and hit return. We will get SG. A total of 2 characters count. Next, Let us quickly auto-fill the rest of the Product Code.
Second, we will learn the RIGHT function by counting the last 5 values from the Address to our Postage Code. Select Cell G4, type in equal, RIGHT, open parentheses. Select Cell E4, comma, space and type in 5. Close parentheses and hit return. We will get 94304, the postage code for Tesla. Next, I will do a quick auto-fill for the rest of the Postage Code.
Lastly, we will learn the Mid function. It is slightly different from the left and right functions. No worries, we will be guiding you through the steps. Select Cell H4, type in equal, MID, open parentheses. Select Cell D4, comma, space and type 5. The 5 tells Excel the number of times it must ignore before its first count. Comma, space and type 3. The 3 represent the number of values we wish to count. As united state’s area code have only 3 digits. Hence, we will use 3 in this case. Close parentheses and hit return. Finally, we will find the rest of the Area Codes.
There you have it, the LEFT, RIGHT and MID functions for Excel. If you have any excel formula you want us to teach, let us know in the comment section below. Don't forget to subscribe, hit the bell button and turn on the notification to have more free excel function tutorials. But, before you go, we have a bonus clip for you. I will be turning this Excel spreadsheet into an API. Stay tuned to see how the magic works.
Convert LEFT, RIGHT and MID Functions into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this LEFT function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select Generate API and click on Generate API. The file is now converting. Okay, your API is ready.
I will now launch this open API that AlchemyJ generates. I will expand this tab, and select try it out. I will input SG001ROCKET and select Execute. Let us check if our LEFT function are working correctly and we are getting SG? Awesome, we got it.
AlchemyJ Studio Excel Add-in turns your Excel business model into API. This way, you can integrate your Excel model into other applications. You can download AlchemyJ Studio Excel Add-in for free at alchemyj.io. And once again, thank you for watching. So which Excel function you wish to be converted into an API? Let us know in the comment section below. Lastly, don't forget to subscribe, hit the bell button and turn on the notification. See you soon.