#Microsoft excel template to add length how to#

Part 1: This part determines the desired text that you want to extract from the characters. Here we need to use FIND & LEN function to determine the number of characters from the given text. In the above example, we cannot just apply RIGHT with specified numbers because the last name of every employee is different.įor the first employee, the last 4 characters are 5, but for the second one,e it is 11 (including space, i.e., Robert Adam), and for the third one, it is 12 (including space, i.e., J. Therefore, TRIM has removed the unwanted space and returned only the text value now, our formula in cell C1 shows both values as TRUE.īelow are the names of the employees, and you needed to extract the Last Name separately. We can remove unwanted spaces by using the TRIM function. , which is why the formula shows it as two different values.īecause of one extra trailing space after the word Excel Formula, it is showing as 14 characters. Apply LEN to A1 and determine how many characters are in the A1 cell.Īpply LEN to B1 to find out how many characters are there in the B1 cell, and in cell B1, 13 characters are there Looking at the outset looks similar, but not able to recognize the difference here.

The values in Cell A1 & B1 look similar, but comparing them in Cell C1 shows me FALSE. We have two similar values in cells A1 and B1, and we need to compare whether both are the same. LEN Function with TRIM is a beautiful combination in Excel. Now I will explain the huge benefit of the LEN function when you want to compare two similar sets of data sets. The reason behind it is that LEN Function counts the characters in the value of a cell and is not concerned with formatting. Here I have taken a date as an example.Įven though the above date has 10 characters, I got only 5.

#Microsoft excel template to add length how to#

So that's how to set up your page sizes, change the measurements, get your margins right, now we're going to go in the next video and look at adding images to our quote.In the below example, I have used the LEN function to count letters in a cell. This looks better, we don't have a lot of detail in a quote so we can kind of center in on the page a little bit more. I'm going to go to 'Wide', that just puts the edges away from- bit of a space, margins between the edges of the page. Next thing I want to do is, I'm still under 'Page Layout', I'm going to go to 'Margins', and I'm just going to make them a little bigger. there it is, 'Ruler units', yours might be set 'Default', so it will pick which country you're in, but say I do stuff for the US all the time, and for you, I have to switch between these two, you might switch it to 'Centimeters' or 'Millimeters'. The other thing we might do is, I've got mine set to inches, you might be setting yours to metric, you might want centimeters and millimeters, you do that over on 'File', down to 'Options', then you go to 'Advanced Options', and somewhere along here, scroll. I'm based in Europe, so I'm going to use 'A4' or 'Letter' I'll use 'Letter' because most of you, my students are based in the US, but let's go along to 'Page layout', and along here it says 'Size', we can switch this from 'A4' which is the default here, for me in Ireland, over to 'US Letter'. The other thing to double check when we get started is the size of our page, and maybe these margins from the edges here. You can toggle back to 'Normal' if you prefer, but 'Page Layout' is going to allow us to kind of get our page size, so there's no point using these cells that are already here, because they're not going to be able to print on one sheet. So what we need to do is go along the top here to 'View', and switch along to this third option here called 'Page Layout'.

Now we want to change this to be more of a page layout, because we're going to be printing this, making PDFs, emailing it, that type of thing. In this video we're going to take this very boring, plain old Excel spreadsheet, and turn it into this page sized boring Excel spreadsheet, just so that we can be using actual US letter sizes, or A4 sizes, we'll look at changing the measurements, the default inches to millimeters as well, getting ready to build our quote in this tutorial series, so let's go and do that now.įirst up, let's create, this first option here, it says 'Blank workbook', and we get our kind of standard Excel layout.