Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
For the final movie in this chapter, please open up EatCake Inventory 15A, if your spreadsheet doesn't look quite like the one that you see on the screen. This function that I'm going to share with you right now, I've used numerous times in the past. And it's really good for creating things like acronyms, or if you have a large spreadsheet that you need to create usernames and passwords for, this is a real time saver, and it's called LEFT. I'm going to use it to create an acronym for the item types that I have.
So I'm going to again, start and select the cell were I want that information to appear. Actually, I think I'm going to move it over just ever so slightly, so it doesn't become part of that table by accident. I'm going to put it in cell I2. I then go up to pick out my function, and the function is LEFT as I mentioned. And what this function does, is it returns the specified number of characters from the start of a text stream. So I identify what texturing I'm interested in working with, so I collapse this dialog box, go over to my worksheet and select B2, because that's the item type.
I come back to my dialog box and open it up, and then I identify the number of characters I want to work with. So I want two characters in my acronym. So, as a preview of what I'm building, I see that I've selected the word Pastry, I've picked the first two characters, so that's going to give me the result Pa. Perfect. That's exactly what I want. I click OK. So I'm starting to build the acronym that I'm going to use within the spreadsheet.
Again, to copy this function down through my column, I click on the grab handle, I pull it all the way down through to the very final row I'm looking at, and I let go. And it's done the same thing all the way through. It's gone through each individual row in the column, and pick the first two letters of every single word that it finds there. In cases where there's no information, it just skips right over. Again, I would like to place in column J, not the function that I'm working with, but the actual values, the P and a.
So I right-click, select Copy, select the cell where I want the information to start to be pasted, right-click, select Paste Special, choose Values, Click OK, and in comes my values. In the next chapter we're going to look at a few more advanced functions from the Function Library. Stay tuned!
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97968 Viewers
80 Video lessons · 141244 Viewers
59 Video lessons · 59606 Viewers
52 Video lessons · 72865 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.