EXCEL clear the formula and keep the raw data obtained

Solved
andalou82 Posted messages 8 Status Membre -  
andalou82 Posted messages 8 Status Membre -
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 réponses

Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Select the column then
Copy / Paste Special / Values

--
Best regards
Patrice
11