How to determine the number of characters or length of cell in excel.
The LEN functions tells you the length of cell in excel or how many characters make up a cell. In this example we would like to extract the second last and third last characters in each of these cells. As you can see everything is different lengths. One of the ways to get around this is to use the LEN function to identify how many characters make up each cell. So I can for example go use the function wizard, find the LEN function. You wil see that all it asks for is point me to the cell you want to count, we will now click on it, and say OK. I am told there are 35 characters in this cell.
Using this information we can now extract these two characters by using the MID function which you can find out more about on the website. So we activate the function wizard, go to the mid function, click OK, for text we point here, the start number, we know the cell now has 35 characters, so this zero is character 35, so we are going to tell it to start at character 35 but go back 1, 2, so there is minus 2, and we want it to show us those 2 characters so its only 2 characters we need to put here and when we say OK you will see we have extracted these characters.
Now when we copy these down, what we should get in each case is, the second last and third last characters, even though these are all different sizes.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd