View original (French)

EXCEL clear the formula and keep the raw data obtained

Solved
andalou82 Posted messages 8 Status Member -  
andalou82 Posted messages 8 Status Member -
Hello,

I have an important file with phone numbers in one column (D) that I obtained using a formula: =IF(C2="","",C2). This formula saves me from doing copy/paste on 800 rows.
How can I remove the formula while keeping its content (phone numbers)?

Thank you for your help

Best regards
Andalou82

2 answers

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    Select the column then
    Copy / Paste Special / Values

    --
    Best regards
    Patrice
    11