Forum Discussion
Question on Replace Function
Hi, I add a new column by copying an existing one and changing the format from numbers to text (copied year column and division new one) then add my text as shown so that i can create a relations...
Anonymous Put comma inside a double quotation and use & like below:
Date.ToText([Invoice Date]) & " , " & [Comments]Hope this answered your question. If, please mark it as a solution!!
Hi,
Will the column add the text when new rows are introduced after refresh because I got conflicting answer?
I attempted to use Custom Column but I don't know how to do it. Can someone share me the syntax i need to use?