1 Reply Latest reply: Dec 3, 2012 2:35 PM by Wayne Contello
Thomas Popp Level 1 Level 1 (0 points)

Hello everyone - quick question:

 

I have some cells in a numbers spreadsheet that I need to have revised. They all have to have "Rycote," Added to the beginning of each cell.

 

What is the easiest way to add this without clicking on each cell and pasting the information? It would take forever because I have 1000 cells to update!!!

 

Thanks in advance!

 

~Thomas Popp


Numbers 09, OS X Mountain Lion (10.8.2)
  • 1. Re: Adding Text to Cells Without Deleting Previous Text
    Wayne Contello Level 6 Level 6 (13,620 points)

    add a new column (which you can remove later) that will pre-pend the text "Rycote" to the contents of an existing cell.

     

    Let's say the exisitng data is in column C and you add a new column D like:

    Screen Shot 2012-12-03 at 4.31.35 PM.png

     

    D1="Rycote"&C2

     

    now select D1, and grab (click and hold) the little circle at the bottom-right corner of the selected cell, then drag down as needed to fill.  Another way to do this (and this is the way you will want to do this is to select D2, copy, then scroll all the way to the end of the column, then shift click the last cell in the column.  This will select ALL the cells in that column, paste to fill them all with the same formula.

     

    Screen Shot 2012-12-03 at 4.34.13 PM.png

     

    The last step is to select column D, then copy, then select column C, then use the menu item "Edit > Paste Values", now remove column D