13

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

migrated from superuser.com Jan 24 '15 at 7:10

This question came from our site for computer enthusiasts and power users.

26

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

  • 1
    & this is why SE is so great, cheers – hello_there_andy Jan 20 '15 at 22:38

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.