Forum Discussion

Mark Carle's avatar
Mark Carle
Copper Contributor
Aug 16, 2018

ADDING to multiple cells

Hi.  Ok, Let's say that I copy a column of 100 item numbers from spreadsheet A into Spreadsheet B.  In spreadsheet B, I want to add .jpg to the end of each item number.  Is there a way to do this in a group fashion, or do I have to copy and paste .jpg into each cell of the column individually? Thanks!

excel
  • Philip West's avatar
    Philip West
    Aug 16, 2018

    lets pretend that your number is in A1

     

    in B1 add this formula =A1 & ".jpg"

     

    then copy the formula down until you have all the file names. You can then either just leave it at that or copy you new column and paste it as 'Values' and then just delete the extra helper column.

  • Philip West's avatar
    Philip West
    Steel Contributor
    Aug 16, 2018

    lets pretend that your number is in A1

     

    in B1 add this formula =A1 & ".jpg"

     

    then copy the formula down until you have all the file names. You can then either just leave it at that or copy you new column and paste it as 'Values' and then just delete the extra helper column.