Results 1 to 6 of 6

Remove formula - keep value?

This is a discussion on Remove formula - keep value? within the Excel Questions forums, part of the Question Forums category; I have a calculation in the cell I have tools/options/calculate on manual formula: =INDEX(A1:A20,RANDBETWEEN(1,COUNTA(A1:A20))) ..thanks Aladin. I obtain a value, ...

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    130

    Default

    I have a calculation in the cell

    I have tools/options/calculate on manual

    formula: =INDEX(A1:A20,RANDBETWEEN(1,COUNTA(A1:A20))) ..thanks Aladin.

    I obtain a value, but when I go to save the file, the worksheet recalculates and changes the value.

    Is there a way once I get my calculated value to erase the formula behind the cell and keep the value?

    Thanks in advance!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    Copy/Paste Special... Values

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    130

    Default

    thank you very much

  4. #4
    New Member
    Join Date
    May 2010
    Posts
    9

    Default Re: Remove formula - keep value?

    Nice one, so simple yet so effective, helped me a lot.

  5. #5
    New Member
    Join Date
    Sep 2010
    Posts
    1

    Default Re: Remove formula - keep value?

    Thanks, this is helpful... I had a follow-up question, though. Is there any way to do this and also preserve hyperlinks? I have a formula that creates a hyperlink in column B out of a string in column A, and I want to be able to get rid of column A while preserving the values (and hyperlinks) in column B.

    Copy/Paste special-values seems to strip the link itself (although it does leave the text blue and underlined.)

    Thanks again in advance!

  6. #6
    New Member
    Join Date
    Aug 2011
    Posts
    1

    Default Re: Remove formula - keep value?

    Also you can do one click on the cell that have the formula then click F2 ---followed by F9---- then click enter.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com