Join Dennis Taylor for an in-depth discussion in this video Formula nesting: Using multiple functions in the same formula, part of Excel Tips Weekly.
- [Instructor] When you work with functions in Excel,…particularly if you're trying to clean up data,…sometimes one function alone is not going to get the job done.…And so it's not uncommon to use more than one function.…We also, as we use functions inside of functions,…refer to the concept of nesting.…In this worksheet here, I've got some data…in columns A and B.…And you can see there's some oddities,…some unusual spacings.…And also all the data's uppercase.…Not truly wrong, but let's say we only want…the first letters to be capitalized.…So if we were focused only on column A,…we might start the process of cleaning this up…by typing a function called proper.…
And referring to cell A2 in this case.…That's what it would look like.…But we also want to combine that with the data in cell B2,…and along with it, let's also consider…the idea of cleaning up the spaces.…So how do we pull these pieces together?…Along with that last name, we also want…to get out of this the first name,…but we want to separate these by a comma and space.…
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.