How to configure data

[CMCesar]

Hey Alteryx community, simple question but I'm trying to use the formula tool to add some text to a column of data. The column of data are all 6 digit numbers and all I want to do is add a "C" in front of all the numbers; i.e. C123456, C234567, etc. 

There has to be a simple way to do this, I'm also open to other forms.

[michelle_mathews]

@CMCesar , use the Select tool to ensure your column of data is a string field then you can use the formula: "C"+[Data Field]

[CMCesar]

Thanks Michelle! 

Another question, within the formula tool. If I wanted to add a column and have the column blank do I need to type in "null" ?

[Jay-RDC]

Hello. You can just type ""