Forum Discussion

abellanc's avatar
abellanc
Regular Visitor
2 years ago
Solved

Combine Column B and Column A with Column A inside a parenthesis

I want to combine Column B and Column A with Column A in parenthesis. I tried text.combine and concatenate but I cannot make it work.   Input A B Dog Tic-Tac Cat Willow Cat Junior ...
  • AlienSx's avatar
    2 years ago
    Table.ReplaceValue(Input, null, (x) => " (" & x[A] & ")", (v, o, n) => v & n, {"B"})