Join Dennis Taylor for an in-depth discussion in this video Use the FIND, MID, LEFT, and RIGHT functions, part of Excel Tips Weekly.
- [Instructor] Excel has a number of functions…that fall under the heading, text.…If you go to the Formulas tab on the Ribbon,…you'll see Text and lots of options here.…A few more common ones are left and right,…where we can pull data out of the left side…of a cell, right side of a cell.…For example, in column A here, we've got some item numbers.…Maybe these are set up on a positional basis.…Maybe it's the three leftmost characters…that refer to the actual location where the item was made,…maybe that's something to do with the size,…or the color or the price, something like that.…
Let's pull out data from the left side of these.…Now, in some of the examples that we're going to be seeing,…a faster and perhaps better approach…could be the use of the Flash Fill feature.…But let's show how we can first use the left function.…We're about to pull out data…from the left side of this cell.…Here's the location and we want…to pull off three characters.…Type it this way, press Ctrl + Enter,…we see what's happening.…Double-click to copy down the column.…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.