Results 1 to 3 of 3

Thread: Convert copy formula to Text in Microsoft Excel

  1. #1
    Join Date
    Nov 2011
    Posts
    120

    Convert copy formula to Text in Microsoft Excel

    Cell C123 contains the value 99. I want cell A1 to display that value (99) and cell B1 to display the formula (=C123). I put =C123 in cell A1. What do I put in cell B1. I know I can toggle between value and formula but how do I get them to both display side-by-side at once.

  2. #2
    Join Date
    Mar 2011
    Posts
    542

    Re: Convert copy formula to Text in Microsoft Excel

    Here is a UDF solution that will work:
    Code:
    Function GetFormula(Cell)
    GetFormula = Cell.Formula
    End Function
    Then in B1 enter =GetFormula(C123)

  3. #3
    Join Date
    May 2011
    Posts
    523

    Re: Convert copy formula to Text in Microsoft Excel

    It can be also done via paste special if you are copy pasting the result. In place of pasting use paste special. Or else there is one more way. First Mark appropriate cell, formula bar is displayed. Second Click on the formula in the formula bar. Third F9 and then press Enter. The formula was removed and the value is entered into the cell. However, if you want to convert many formulas to values, please consult the appropriate area (or just about anything) and copy it. "Insert file / contents / values", you can now insert the data from the clipboard at the same point. The formatting you can insert in a second step in the same way.

Similar Threads

  1. Looking for formula that can ignore text values in Excel
    By Henriksen in forum MS Office Support
    Replies: 3
    Last Post: 23-02-2012, 07:20 PM
  2. How to put formula in Text Box in Microsoft Excel
    By TheCarter in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 05:58 PM
  3. How to Copy formula using Vlookup on Excel?
    By Chellappan in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 08:20 PM
  4. Replies: 0
    Last Post: 18-03-2009, 10:00 PM
  5. Excel Formula to convert lastlogontimestamp to date
    By Allanoo in forum Active Directory
    Replies: 0
    Last Post: 30-11-2006, 10:18 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,646,534.67299 seconds with 17 queries