"First, if you type ""Taro Yamada"" in A1 with the cell you want to refer to as A1
"
= "My name is ""&A1&""
"Then, the cell says ""My name is Taro Yamada"", but
"
Attempting to display "name": "Taro Yamada",
"=""name":"&A1&""," will naturally result in an error.
How do I print the string "name": "Yamada Taro", to the cell?
Note:
"Enter ""Taro Yamada"" in the A1 cell
"
"I would like to refer to the contents written in the A1 cell and display ""name"": ""Taro Yamada"" on the B1 cell."
"In other words, if the contents written on the A1 cell are changed to ""Yuki Sato"", the B1 cell is changed to ""name"": ""Yuki Sato""."
Thank you for your cooperation.
="""name"":"""&A1&"","
The reference material below is Excel, but I could do the same with Google spreadsheet.
Excel: Enter "(double quote)" as a character in the expression
In google-spreadsheet, write two double quotation marks (") in a string.
If hello "world",
="hello""world""So I'm going to write the following.
="""name"":""&A1&"""
Additional information
It seems to be a comma at the end, so correct it
="""name"":"""&A1&"","
© 2024 OneMinuteCode. All rights reserved.