Well, I did some research but I didn't find what I'm trying to do. I have this text:


I have 4 columns with information in each cell. I need to "import" each cell information inside that, so I would get exactly this:

"en":"Hi", "es":"Hola", "it":"Ciao", "pt":"Olá"


1 Answer 1


What you need is this:

="en:" & B2 & ", es:" & C2 & ", it:" & D2 & ", pt:" & E2


(following your comment)

To preserve/include quotation marks("), escape/prepend your "s with another ".
In your case you should use:

="""en"":""" & B2 & """, ""es"":""" & C2 & """, ""it"":""" & D2 & """, ""pt"":""" & E2 &""""

enter image description here

  • Thank you. It works, but it deletes the quotation marks, and I need them to be there. Is there a way to keep all quotation marks? Commented Sep 3, 2019 at 15:11
  • Do you need quotation marks in both the language as well as the words ("en":"Hi") or just the words? (en:"Hi"). I would personally suggest just the words. Commented Sep 3, 2019 at 15:24
  • I need them both because the idea is to create a cell that I can just Copy+Paste. Commented Sep 3, 2019 at 15:42
  • Please check the updated formula. Remember to accept (and upvote). Commented Sep 3, 2019 at 15:50
  • It works, but when I Copy and Paste, it pastes the extra quote marks. :'( Is there a solution for this? Commented Sep 3, 2019 at 16:13

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.