Formula nesting: Using multiple functions in the same formula

- [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.…