### MS Excel Functinos (LEFT, MID, RIGHT, LEN, MID+LEN)

Hello guys! In this post I'm gonna write about some basic functions of Excel i.e. left, right, mid, len & mid+len. Normally they look really simple. But they can be of great use if you know how to combine them with other functions . . .

In this tutorial I'm not gonna discuss about complex use of these functions. I will simply show you the basic use of them. Hopefully next time you will see the advanced use of these functions.

Let's start with the image above. There are mainly 04 formulas i.e. Left, Mid, Right & Len. And the next 02 are combinations of Mid and Len functions.

I've tried to explain every formula in this image. I guess nothing is ambiguous with these 04 functions.

You might be confused with the combinations. In the 1st combination the 02 functions are simply merged.

But in the 2nd combination you should notice that len function is not used. Instead we've used the len column i.e. G2. That is the difference. 1st combination requires to merge len function with mid. It doesn't require any other column. But 2nd combination is using a different len column instead of merging len function with the mid.

Well I'm not interested to discuss any longer. I've uploaded the project file. You can download it from here -

You should practice by yourself and I hope you will get this easily. If you face any problem then comment below. Thanks for staying with Marks PC Solution . . .

### GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALLCARSGOB