I am trying to make life easier for myself by organising my teaching materials for private tutees of mine from various subjects/educational levels in google spreadsheets.

I want to know how I can take a string literal such as "Paper " and concatenate it to the string of characters as they appear in another cell using a formula.

enter image description here


2 Answers 2


It looks like you want the & operator

I'm not quite clear which thing you are concatenating to which in the question; however, you can do either

=$BJ$2 & "24"


=$BJ$2 & BH1


="Paper" & BH1

assuming you are on row 2 and the number is on row 1 (the $ locks the cell so that it doesn't change when copying/pasting).

Here's an example with a test spreadsheet: example

  • 1
    & this is why SE is so great, cheers Commented Jan 20, 2015 at 22:38
  • & worked great ! Commented Apr 2, 2020 at 7:04
  • @NextlnLine perfect!
    – harikris
    Commented Feb 7, 2021 at 6:10

It seems like there's an alternative option.

For a similar case, I used Array Formula and SUBSTITUTE hack. It makes formulas readable and helps with more complex joins. I found this option in this article. It worked smoothly.

I hope it'll help you too

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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