Tag: LEN

Lesson#112: Calculate the match percentage of text which matches another text.

Here I will discuss a interesting formula. With this formula we can calculate percentage of a text matching with another text. In the above picture I have shown two cells. First cell having a long text value and the second

Tagged with: , ,

Lesson#111: Extract parts of text separated by special character

Here I will show you how to extract parts of text separated by a special character. In the above image I am having some structure id. Each text have four parts separated by “/”. Each parts has a different meaning.

Tagged with: , , , , ,

Lesson#107: How did I add MS Project features in Excel project schedule

Here I will discuss a long topic about Excel gantt chart making. I will show how I made my excel chart work like ms project schedule by adding some basic features. Some basic features of ms project which I added

Tagged with: , , , , , , , , , , , , ,

Short Tips#0063: Formula to find number appearance of a character in a text

Tagged with: ,

Short Tips#0049: Formula to separate first name and last name

Tagged with: , , ,

Lesson#100: Making a master formula to separate words from sentence

Hello. Now we will learn how to make a master formula to separate words from sentence. For that I will use functions, TRIM, MID, SUBSTITUTE, REPT, LEN. 1st step: I will change the text by replacing all the <SPACE> with multiplying the

Tagged with: , , , ,

Lesson#99: Formula to separate first name, middle name, last name from a full name

OK. I am back again with some crazy formula. Here in this post I will show you how to make a formula to separate first name, middle name, last name from a full name. Here in this above picture I have

Tagged with: , , , , ,

Short Tips#0003: Finding exact middle character(s) of text

Tagged with: , , ,

Lesson#59: If A=1, Z=26 then calculate the value of your name

This sheet can calculate the value of your name or any word by summing every letter with 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

Tagged with: , , , , ,

Lesson#22: How to find the exact middle character(s) of text using LEN

LEN is a function which is used for finding out number of characters in a text string. It’s syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG has 43 characters including <space> between words. Now I will show

Tagged with: , , ,
Top