Converting formulas to values with a simple drag

- After creating certain formulas,…there are times when you want to say, in effect,…let's not keep the formula, but let's keep the results.…As we look at this data on the worksheet…called ConvertFormulasToValues,…the data in column A maybe isn't quite…what we want it to look like.…We don't want everything to be capitalized.…We want just the first letters…of people's names to be capitalized.…So, instead of retyping all these,…all we want to do is to insert a new column…to the left of column B.…We can right-click, or control click, column B,…and then choose Insert.…

We're going to use a function…that's used elsewhere in this course.…It's called =proper.…And referring to cell A2, it simply will…make only the P in Page and the L in Lisa capitalized.…All other letters will be lowercase.…Simply press control, enter so the active cell doesn't move,…and then double-click the lower right hand corner.…And once again, pressing control, period…just to make sure this got copied…to the bottom of the column.…It did.…Press control, period.…