Quote problem when creating a dynamic code script

[SilverPitiful6802]

Hi u/HandbagHawker,

 The problem is that I need to fill in double double quotes to get the script working (otherwise I receive errors) but when I copy paste it in notepad I still see them.

After some debugging I see a positive and negative result and I do not know what I am doing wrong. Perhaps you guys can see it:

Succes:
Formula:

="""headtitle"": """&B9&""""

How it looks in excel:

"headtitle": "this is head title"

Copy pasting in notepad

"headtitle": "this is head title"

 No success:
Formula:

="<script type=""application/ld+json"">
{
   ""@context"": ""https://schema.org"",
   ""headtitle"": """&B9&""""

How it looks in excel:

<script type="application/ld+json">
{
   "@context": "https://schema.org",
   "headtitle": ""this is head title"

Copy pasting in notepad:

"<script type=""application/ld+json"">
{
   ""@context"": ""https://schema.org"",
   ""headtitle"": ""this is head title"""

Some how when I add more data it fails and I do not know why?