Output an Excel formula

[yozveren]

Hello,

My question might sound stupid, but here I go.

Once the Alteryx Excel file Output comes, I would like that the Excel cells of a specific column from that file reads: =TEXTE(B8&" - "&C8&" - "&D8&" - "&E8;"")

So I create a formula in Alteryx, create the column, and copy paste the expression in the formula and then put " " at the beginning and the end:

"=TEXTE(B8&" - "&C8&" - "&D8&" - "&E8;"")"

However, Alteryx naturally considers the " in order, instead of only taking into account the first and last one.

How can I make this work ? Basically, how can we write " in a formula ?

I hope that my question is clear, let me know if not.

Thank you

[BenMoss · Accepted solution]

You can write " as text by using single qoutes instead as the value that starts and ends text.

'=TEXTE(B8&" - "&C8&" - "&D8&" - "&E8;"")'

[yozveren]

Was a stupid question after all.

Thank you very much!

[PaulN · Accepted solution]

Hi @yozveren,

Thank you for posting.

You may replace the external double quotes by single quotes.

Kind regards,

Paul Noirel

Sr Customer Support Engineer, Alteryx