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,
Your code is great. Is it possible to capture the Text without the year as shown?
//NT
Anonymous Based on my understanding, you’d like to concatenate the ‘Division’ column with the ‘Year’ column and change the data type to text.
To achieve this, simply replace the hardcoded value ‘IND’ with the actual column name ‘[Division]’ and update the data type accordingly.”
Feel free to ask if you need further clarification or assistance!
If this answered your question, please mark it as solution!!