Bu88les
Level 1 (0 points)

Q: How do I copy a formula result as text in numbers?

I want to copy the column of results driven by a formula but just as text. i.e., i want to copy the text to a new column without copying the formula over so that I can delete the original columns of data that provided these results

Posted on Sep 24, 2015 2:33 AM

by Wayne Contello,Apple recommended
Wayne Contello Wayne Contello
Level 6 (19,421 points)
iWork
A:

select the column, copy

 

select the destination, select the menu item "Edit > Paste Formula Results"

Posted on Sep 24, 2015 5:03 AM

Close
Bu88les

Q: How do I copy a formula result as text in numbers?

  • All replies
  • Helpful answers

  • by Wayne Contello,Apple recommended

    Wayne Contello Wayne Contello Sep 24, 2015 5:03 AM in response to Bu88les
    Level 6 (19,421 points)
    iWork
    Sep 24, 2015 5:03 AM in response to Bu88les

    select the column, copy

     

    select the destination, select the menu item "Edit > Paste Formula Results"

  • by Barry,

    Barry Barry Sep 24, 2015 4:57 PM in response to Bu88les
    Level 7 (32,721 points)
    iWork
    Sep 24, 2015 4:57 PM in response to Bu88les

    Copy always copies the contents and format of the cell. The contents in this case are the formula (and it's current result).

    But you can Paste Formula Results using that menu item in the Edit menu.

     

    If you intend deleting the original column following the paste, there's no real need to create a new column, paste into it, then delete the original column. You could instead:

     

    Select and copy the original column (containing the formulas)

    With the column still selected...

    go Edit (menu) > Paste formula results.

     

    Regards,

    Barry

  • by PlutoCW,

    PlutoCW PlutoCW Aug 24, 2016 7:00 AM in response to Wayne Contello
    Level 1 (4 points)
    iWork
    Aug 24, 2016 7:00 AM in response to Wayne Contello

    Is there a way to do this automatically i.e. when I click on checkbox?

  • by t quinn,

    t quinn t quinn Aug 24, 2016 7:46 AM in response to PlutoCW
    Level 5 (5,063 points)
    Mac OS X
    Aug 24, 2016 7:46 AM in response to PlutoCW

    Hi Pluto,

     

    There is no way to do this simply checking a checkbox.

    Copy>Paste Formula Results is your quickest way to go. Hardly more work than clicking a checkbox. As Barry suggests you don't even need to paste into a different column.

     

    quinn