Adding quotes around cell in formula?

Question

I am trying to create a formula that will help me in creating sql query

In Excel this is what I have written down:-

=CONCATENATE("UPDATE T_KeyAttribute set description=",B3," WHERE KeyName=",A3)

This gives me for example:-

How can I add quotes around the values of B3 and A3 (i.e. around their text values)

Put the double quotes inside double quotes as a piece of text. — Solar Mike, Jul 22 '21 at 07:58
@SolarMike so I did, =CONCATENATE("UPDATE T_KeyAttribute set description=","""&B2&"""," WHERE KeyName=",A2). Doesn't work — Shad, Jul 22 '21 at 08:08
Don’t mix concatenate and &. & does do concatenation but uses fewer characters. — Solar Mike, Jul 22 '21 at 08:10

score 1 · Accepted Answer · answered Jul 22 '21 at 09:40

1

="UPDATE T_KeyAttribute SET description ='"&B3&"' WHERE KeyName = '"&A3&"'"

This will return:

UPDATE T_KeyAttribute SET description = 'Text1' WHERE KeyName = 'Text2'

answered Jul 22 '21 at 09:40

Xyloz Quin

score 1 · Answer 2 · answered Jul 22 '21 at 13:44

1

I like using CHAR(34). You might find other strategies that you can use for your specific situation here

="UPDATE T_KeyAttribute set description="&
CHAR(34)&B4&CHAR(34)&
" WHERE KeyName="&
CHAR(34)&A4&CHAR(34)

answered Jul 22 '21 at 13:44

EDS

2 Answers2