Insert Equal Sign as prefix into excel output

[k3pineapple]

Hi Team,

Seeking your help to make "=" as the start of the excel record, not sure it is possible or not.

Input

ID	data1	data2	Tool	formula
1	123	455	+	123+455
2	222	345	x	222x345

Output in excel:

ID	data1	data2	Tool	formula
1	123	455	+	=123+455
2	222	345	x	=345x345

[OTrieger]

@k3pineapple 

I'm not sure if I understand your question, as it is possible to do it in Alteryx but in excel it will be a in a text format.

So what is your question? Are you asking if Alteryx will output =345x345 in excel your will get the calculated value in the cell based on this formula?

[k3pineapple]

@OTrieger , thx for the help

Want to output  "=345x345" into the excel cell, not the calculated value.

How may i convert it to text format in Alteryx? thx thx

[dYoast · Accepted solution]

@k3pineapple :  Use a formula tool to create the string.  "'=" + [data1] + [Tool] + [data2].  Note the single apostrophe before the equals sign.  This will tell Excel to interpret the field as a string instead of a formula.

You may need to use the ToString function for data1 and data 2.