Simple Excel Tips, Tricks & Formulas for Daily Use.

Today, I am going to lay down some tips and tricks which you can use in your daily life. Without wasting time i should move on with some tips regarding excel.

How to fix an excel cell in formula

If you are writing any formula which needs to take reference to a particular cell. Then, you should have to fix that particular cell, so that your whole formula won't be a mess.

There is much more need of this fixing trick but over here in this particular article i am going to show the use of this trick with a simple example.

From figure, 

C13= 40% be the required percentage to be taken out from A, B, C.

In G3, Write your formula as: =C3*D3, you will get the desired result but what if, if you want to copy that formula, To B and C. If you simple copy and paste the formula or simply drag it. You will get the wrong formula as the formula will keep moving in relation to the cell.

In order to solve this problem, you should fix the particular cell, which is cell C3. So that, A, B, C will relate to the Percentage in C3.

To do this, just type: $C$3 in the place of C3 in the formula, So the new formula should look like this, in G3: =D3*$C$3, now you can copy and paste the formula to I3 you will get your desired result.

The Use of Concatenate Function

The use of concatenate function is an addition if you know how to use this, What it actually does is that, it combines the text in different cell into one.

From Figure,

There are string of texts in D3, E2 and F3, I used the function called concatenate in D6.

What i did was, used =Contatenate(D3,E2,F3).

You can see the Result in D6.

The Use of Left, Right & Mid Function

What these function does is just opposite to the one that the concatenate function does.

Left separate the left string of the particular text string.

Right Function will separate Right side String form the particular text string.

Mid function will separate Mid string of the particular text string.

From Figure,

Lets Play with a string of text called "This is for a test purpose" which is in Cell B2.

I typed in C5 as: =left(B2,5). Why is that 5 for? 5 is the no. of characters which it will take from the Left hand side from B2. Note:(Space) is also count as an character, so "This " = 5 character is there in cell C5.

I typed in D5 as: right(B2,5). This has the same explanation as of above. Simply it starts from the right had side of the text string in B2.

I typed in E5 as: mid(B2,6,5). B2 is the reference cell, 6 is no. of characters from left hand side (to start copying), 5 is how many characters further you require to copy.

Hope you liked this article.

Check out other similar articles on excel, below. Thank you.