Converting formulas to values with a simple drag

Sometimes in Excel when you write formulas and functions, you want to …actually take the results of the formulas and essentialy turn them into pure values. …In other words, throw away the formulas, and keep the results. …In this particular worksheet, called ConvertFormulasToValues, we've got …formulas in column B that take the employee names and display them with only …the first letters capitalized. It's by way of a function called proper. …And so let's say that column A is not the way we want our data to look, but column …B is. And yet, right now, column B depends upon …column A. We're using the function called Proper to …give us the results we want. So what we'd like to be able to do is …convert these formulas into values. There's a very fast and efficient way to …do this. And we'll show you another example over …in column K. First, let's look at column B here.…

What we want to do is freeze these results. …Remember they're all formulas in column b and it would be kind of a cheap trick and …