Hello,
I am trying to create a formula that uses text and symbols but Excel doesn't like it. Here's an example:
I would like to have cell B2 be inserted into where the B2 is shown in the above script but because my text has so many quotes in it i think excel is getting confused. Is there a way to build a formula that will have an end result of:
/system identity
set name="Jane Doe"
/system logging
set 0 action=disk disabled=no prefix="" topics=info
set 1 action=disk disabled=no prefix="" topics=error
set 2 action=disk disabled=no prefix="" topics=warning
set 3 action=disk disabled=no prefix="" topics=critical
I am trying to create a formula that uses text and symbols but Excel doesn't like it. Here's an example:
Rich (BB code):
="/system identity
set name=""&b2&"""
/system logging
set 0 action=disk disabled=no prefix="" topics=info
set 1 action=disk disabled=no prefix="" topics=error
set 2 action=disk disabled=no prefix="" topics=warning
set 3 action=disk disabled=no prefix="" topics=critical"
/system identity
set name="Jane Doe"
/system logging
set 0 action=disk disabled=no prefix="" topics=info
set 1 action=disk disabled=no prefix="" topics=error
set 2 action=disk disabled=no prefix="" topics=warning
set 3 action=disk disabled=no prefix="" topics=critical