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.
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.
- Put the formula
- Extend it to a large enough range so that it processes all of your data.
- Cut the results: CtrlX or its equivalent on Mac.
- Paste values only back to the original range: CtrlShiftV or its equivalent.