I am trying to concatenate many cells of a Google Sheets with "1 " in front of every cell. There are 360 cells so changing each individually would be a difficult task.

  • 1
    If this is something to be done once, just put a formula ="1 "&A1 somewhere, extend to a large enough range, then copy the results and paste special - only the values - back into original range. – user79865 Dec 5 '15 at 6:52
  • @NormalHuman thanks so much for the help. – user202729 Dec 5 '15 at 7:08

For a one-time replacement like this, an easy thing to do is to carry out the computation elsewhere on the sheet (or in another sheet), and then copy-paste the values back in.

  1. Put the formula ="1 "&A1 somewhere.
  2. Extend it to a large enough range so that it processes all of your data.
  3. Cut the results: CtrlX or its equivalent on Mac.
  4. Paste values only back to the original range: CtrlShiftV or its equivalent.
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.