Updated: Aug 24, 2021
We will learn how to change to case of value in your Excel spreadsheet to UPPER, LOWER and PROPER Cases for today's tutorial. We will be showing you 2 methods, first by Formula and second by Flash Fill.
We will also show you how to convert your PROPER 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/
We will learn how to change to case of value in your Excel spreadsheet to UPPER, LOWER and PROPER Cases for today's tutorial. We will be showing you 2 methods, first by Formula and second by Flash Fill. Without further ado, let us get started.
How to use UPPER, LOWER and PROPER Functions
In our Excel spreadsheet, you will notice that our First and Last values are entirely mess up by a corrupted excel file. No worries, we will clean this up together.
First, let us find the full name in our excel spreadsheet by using the CONCAT function. Select Cell D4, type in equal, CONCAT, open parentheses. Select Cell B4, type in Ampersand, open quote. Click on space, open quote, Ampersand and Select cell C4. Hit Return. You will get a messy value of Elon Musk’s full name. Next, we will find the remainder full names value. Move your cursor to the lower right of Elon Musk’s Full name. Once your cursor turns into a cross. Double click on it. You will get full remainder names.
First, let us make all our first names into UPPER Case. Select Cell E4, type in equal, UPPER, open parentheses. Select Cell B4, close parentheses and hit return. You will get ELON in UPPER Case. Now, let us find the remainder UPPER case full name.
Second, we will find the Last Name in LOWER case. Select Cell F4, type in equal, LOWER, open parentheses. Select Cell C4 and hit return. You will get musk in LOWER case. Next, let us find the remainder LOWER case full name.
Thirdly, we will use PROPER to capital the first alphabet of our names. Select Cell G4, type in equal, PROPER, open parentheses. Select Cell D4 and hit return. You will get Elon Musk with the first alphabet in capital. Next, let us find the remainder PROPER case full name.
Lastly, I will be using the Flash Fill method. First, select Cell E4 and type in Elon in the UPPER case. Now, select Cell E5 and type in B. The Excel will recognise the first cell as an UPPER case and show a list of UPPER case names. Next, click on Jeff. Excel will Flash Fill the remainder names in your excel spreadsheet.
There you have it, the UPPER, LOWER AND PROPER 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 PROPER Functions into Application Programming Interface (API)
I will be using AlchemyJ Studio Excel Add-in to turn this PROPER functions 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 TONY JOHNSON and select Execute. Will we get Tony Johnson with the first alphabet in UPPER capital and the rest of the LOWER capitals? 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.