Tag: MID

Lesson#117: How to split up characters of text in excel

Here I will show you a nice trick to split up characters of text in excel. You can see in the above picture I am having a merged cell to put a text in it. I will develop a formula which

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#110: Separate characters from text where any word appears

Here I will show how to separate characters from text where any text appears. Here in the above picture I am having some text values which contains the word “made”. I will show you how to part out text value

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: , , , , , , , , , , , , ,

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#0014: MID function

Tagged with:

Short Tips#0004: How to extract characters from a text

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: , , , , ,
Top