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!!
Anonymous As I can understand, that you want to create a key column to develop relationship with other tables. Yes, If you create a column based on other columns, as you mentioned, and add specific text, after refresh, the new column will automatically update whenever new data is added to the source file.
If this answered you question, please mark it as solution.