Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You may find yourself wanting to add special characters into your document. You can do that quite easily with the Insert Special Characters dialog. For example, let me go into this cell and add a registered trademark symbol after the word Microsoft. I can go Insert > Symbol, and from the list of special characters, choose the registered trademark, here it is, and click Insert, or I could click and drag that into place. If you change your font set you're going to change the characters that are available, and while we're on this page, let me close this dialog, this text has been imported earlier. You may remember we imported it from the web, from the Microsoft web site. It's a small segment of text that was brought in from the overview of Microsoft Office, particularly Excel 2003. Now when we imported it from the Microsoft web site, it was nearly perfect. I went ahead and made this mess just so I could show you the next function. Sometimes when you're importing data from various data sources, you'll end up with a less than perfect text layout. As you can see here, there are far too many spaces in this text and it's probably because it came from a very dirty data source. One of the functions that we have at our disposal that is intended to work with text, is the Trim function. You'll say =TRIM, and we'll tell it to look at A2. The result is all of the extra spaces being trimmed out of that statement and now it's a nice complete sentence again.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90578 Viewers
80 Video lessons · 137945 Viewers
59 Video lessons · 56687 Viewers
52 Video lessons · 70307 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.