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 Yes it is possible.
1. Division with invoice amount - [Division] & Number.ToText([Invoice amount])
2. Invoice Date with comments - Date.ToText([Invoice Date]) & [Comments]
Hope this answered you question. If, please mark it as a solution!!
this is great...how can i add comma to distinguish between the 2 data
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!!