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


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

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.