Google Sheets Concatenate – How to Concatenate a String Literal with Another Cell

concatenategoogle sheets

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

Best Answer

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"

or

=$BJ$2 & BH1

or

="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

Related Topic