Import cells into the text of another cell preserving quotation marks

Question

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

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

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

Welcome. Thank you for sharing your efforts. Also check How to Ask and About asking. As per site guidelines when an answer addresses your question, you should accept it so others can benefit as well -. (Why vote?) — marikamitsos, Sep 3, 2019 at 14:55

Community · Accepted Answer · 2020-06-16 10:46:08Z

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

CommunityBot

1

answered Sep 3, 2019 at 14:55

marikamitsos

12.6k3 gold badges27 silver badges54 bronze badges

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, 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.
– marikamitsos
Sep 3, 2019 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, 2019 at 15:42
Please check the updated formula. Remember to accept (and upvote).
– marikamitsos
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?
– Roberto de Nobrega
Sep 3, 2019 at 16:13

| Show 2 more comments

1 Answer 1