Basic Excel Function - How to use LEN Function

Updated: Nov 15


Today we will be learning the LEN Function. The function returns the number of characters in a text string. In other words, the function counts alphabets, numeric, space and punctuation. However, number formatting is excluded.


We will also show you how to convert your LEN function into an API at the end of the video.


Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download


Learn More:

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/


Article


Today we will be learning the LEN Function. The function returns the number of characters in a text string. In other words, the function counts alphabets, numeric, space and punctuation. However, number formatting is excluded. Without further ado, let us get started with some examples.


How to use LEN Function


Let us use the LEN function and count the number of password characters in our Excel spreadsheet. First, we will count the length of the character of the text that has alphabets and numeric and no space and number formatting. Select Cell D4, type in equal, LEN, open parentheses. Select Cell C4 and hit return. You will get 8 characters.


Now, let us auto-fill the rest of the rows. In Cell D5, we will get 13 characters. The characters length includes the space in between Delta and Variant. In Cell D6, we have gotten 3 and not 6. This is because the LEN function has excluded all values after the decimal point. Thus, we will get 3 characters.


Advance Excel Tip. Let us combine the LEN and IF function, validate the passwords, and check if it has less than 8 Characters. Select Cell E4, type in equal, IF, open parentheses. Type in LEN and open parentheses. Select Cell C4 and close parentheses. Type less than 8, comma, space and open quotes. We will now input the message, “Input 8 Characters Password”. Close quotes, comma, space and open quotes. Next, we will input the message “Password Length is Okay”. Close quotes and parentheses and hit return.


Iphone13 has 8 characters in length. Thus, we get the message of “Password Length is Okay”. Now, let us auto-fill the rest of the rows. We will see “Input 8 Characters Password” in E6. This is because the password is 100 and it has only 3 characters in lengthoday we will be learning the LEN Function. The function returns the number of characters in a text string. In other words, the function counts alphabets, numeric, space and punctuation. However, number formatting is excluded.

Intermission

There you have it, the LEN function 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 LEN Function into Application Programming Interface (API)


I will be using AlchemyJ Studio Excel Add-in to turn this LEN function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select AlchemyJ Tab, 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 A to H a total of 8 characters and select Execute. Let us check if our LEN function is able to show us 8. Awesome, we got it.


Closing


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.

42 views0 comments