how to concatenate a string and cell value in excel if the string already has quotes?

Question

="python sql.py --table process --query-type UPDATE --column-value active='N' --where ""pid=9999 and data_id=""&A1&"""

I need A1 to be whatever is in cell A1 but the formula is treating it as a part of the string

the final output should be

python sql.py --table process --query-type UPDATE --column-value active='N' --where "pid=9999 and data_id=0001"

How to create strings containing double quotes in Excel formulas? https://stackoverflow.com/q/216616/992406] — houssam, Jan 18 '21 at 13:09

score 0 · Accepted Answer · answered Jan 18 '21 at 13:08

0

Try:

="python sql.py --table process --query-type UPDATE --column-value active='N' --where ""pid=9999 and data_id="&A1&""""

answered Jan 18 '21 at 13:08

JvdV

1 Answers1