OK. I am back again with some crazy formula. Here in this post, I will show you how to make a formula to separate words from a full name. Here in this above picture, I have a list of names …
Lesson#99: Formula to separate words from a full name Read more »
This sheet can calculate the value of your name or any word by summing every letter in alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more »
LEN is a function that is used for finding out the number of characters in a text string. Its syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG has 43 characters including <space> between words. Now I will …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more »
