Excel - Insert values into text

Question

Navigation

#1 by (0 votes)

0

Good,

I am creating an excel where I would like to insert values (in function) into text. I want to pass values from Column F12 to H12.

I want to enter text here where it says [here]

 UPDATE public_ads SET ads_price = [aqui] WHERE ads_reference = [aqui];

How do I make excel to auto-enter depending on a new line?

excel

asked by anonymous 28.10.2018 / 12:55

1 answer

score 0 · Answer 1

0

You can use the CONCATENATE formula as below

=CONCATENAR ("UPDATE public_ads SET ads_price = [";F12;"] WHERE ads_reference = [";H12;"];")

29.10.2018 / 12:52