Convert Excel formula into fixed values or text


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Changing an Excel formula into the values is amazingly easy.  It’s just a copy and special paste.

Another way to think of it is deleting the formula but leaving the results in the cells.

  1. Select the cells. In this case from our article on converting text cells into Excel dates.

    convert excel formula into fixed values or text microsoft excel 24379 - Convert Excel formula into fixed values or text

  2. Copy them, using Ctrl + C or Home | Clipboard | Copy

    convert excel formula into fixed values or text microsoft excel 24382 - Convert Excel formula into fixed values or text

  3. Keep the same selection of cells for the next step
  4. Go to Home | Clipboard | Paste menu and choose Paste Values | Values from the list.

    convert excel formula into fixed values or text microsoft excel 24381 - Convert Excel formula into fixed values or text

The cells look the same, but check the formula line to see that it’s now the value not the formula.

Make a mistake?

No problem, Undo or  Ctrl + Z  will restore the formulas.

Selecting an array

If it’s an array, a different selection process applies.

Go to Home | Editing | Go to Special then choose Current Array.

convert excel formula into fixed values or text microsoft excel 24383 - Convert Excel formula into fixed values or text

 

subs profile e1563205311409 - Convert Excel formula into fixed values or text
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address