Tag: FIND

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

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

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