Who says Excel Functions for Numbers? TEXT FUNCTIONS!

I remember my first class in Excel and my tutor told me that MS Word originated from a Typewriter! MS PowerPoint Originated from the Overhead Projectors !MS Access Originated from a Filing Cabinet and MS Excel originated from a calculator. When I told my tutor i was scared of Excel because I am not good with figures! She told me that I was going to have a big problems with my girlfriends in the future!

I think there was some kind of misunderstanding between us as her interpretation of figure was totally different than mine! Anyways now that I have become a trainer myself and when i see people being scared of MS Excel as may be they had the same problem as me where either they did not find Maths Comfortable or may be they had a tutor like mine who had a habit of misunderstanding me. I tell the them that imagine Excel to be a Large Calculator which is there to make your life lot more easier! Well lots of people just think Excel as a calculator and don't realised that there is a great more deal MS Excel can do for them. Although there are lots and lots of Functions that are suitable for various industry but i would like to focus on the TEXT Functions:

Unfortunately, I am not going to explain each and everyone. I'll explain some and then may be refer you to some websites where you can download free course manuals and learn more of the functions.

The Functions I want to talk about are:

UPPER - This capitalises all the letters in a specific cell

lower - This make all the letters small case in a specific cell

Proper - this is like the Title case in Word where first letter of each word becomes capital

Left - This extracts certain no. of characters from the left in a cell

Right - This extracts certain no. of characters from the Right in a cell

Mid - This extracts certain no. of characters from the middle in a cell
LEN - Tells how many characters a word has in a cell

Rept - Repeats the word in a cell specific no. of times

Instead of me going through all of them individually let me attach a screen shot which gives example of all of the above.

If you need to know more type of function please feel free to go to the Mouse Training Website and download their Free training Manuals

Many thanks

Raj