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


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

| improve this answer | |
  • 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? – Roberto de Nobrega Sep 3 '19 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. – marikamitsos Sep 3 '19 at 15:24
  • I need them both because the idea is to create a cell that I can just Copy+Paste. – Roberto de Nobrega Sep 3 '19 at 15:42
  • Please check the updated formula. Remember to accept (and upvote). – marikamitsos Sep 3 '19 at 15:50
  • It works, but when I Copy and Paste, it pastes the extra quote marks. :'( Is there a solution for this? – Roberto de Nobrega Sep 3 '19 at 16:13

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.