Forum Discussion

spicegirl326's avatar
spicegirl326
Copper Contributor
Mar 22, 2024

REF! Error Please help

Used a formula to collect data when I copy the data to a new spread sheet I am getting REF! error.  I have tried every which way to correct this and I am not understanding.    I used the =LEFT(B2,2...
  • SergeiBaklan's avatar
    Mar 22, 2024

    spicegirl326 

    Depends on what you'd like to have in another sheet. If values, when copy 135 cells with formulae, in another sheet Paste->Paste Special->Values

Resources