Forum Discussion
Replace Values - Text & Cell Value
Hello, I am trying to Replace values, where the result would be a concatenation of a text & a cell value. For instance "Transaction Date 12/06/2022", but I am stuck with how to combine "Transacti...
Hi Anonymous ,
Based on your sample data, I reproduced it and you can modify your formula as follows to get your expected result.
= Table.ReplaceValue(#"Changed Type","",each "Transaction Date "&Text.From([Transaction Date]), Replacer.ReplaceValue,{"JE Memo"})Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Based on your sample data, I reproduced it and you can modify your formula as follows to get your expected result.
= Table.ReplaceValue(#"Changed Type","",each "Transaction Date "&Text.From([Transaction Date]), Replacer.ReplaceValue,{"JE Memo"})
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.