• Convert Formula to Values after calculation

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Convert Formula to Values after calculation

    Author
    Topic
    #495019

    I have used a vlookup to retrieve information, now I want the resultant information to stay and remove the formula. How do I do this?

    Kerry

    Viewing 1 reply thread
    Author
    Replies
    • #1455224

      Copy the cell then Right click on the cell and select “Paste Values”, or “Paste Special”.

      cheers, Paul

    • #1455225

      Too easy!!! Thanks Paul.

    Viewing 1 reply thread
    Reply To: Convert Formula to Values after calculation

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: