How to Convert Text Function Formulas to Text

By Stephen L. Nelson, E. C. Nelson

You might need to know how to convert an Excel formula — such as a formula that uses a text function — to the label or value that it returns. For example, suppose that you find yourself with a worksheet full of text-function-based formulas because you used the text functions to clean up the list data. And now you want to just work with labels and values.

You can convert formulas to the labels and values that they return by selecting the worksheet range that holds the formulas, choosing the Home tab’s Copy command, and then choosing the Home tab’s Paste→ Paste Values command without deselecting the currently selected range. Note that to get to the Paste submenu, you need to click the lower half of the Paste command button.