Forum Discussion
Combing columns
I know this is a basic question, I am trying to combine columns while adding a space and the & sign. Column A is the client's 1st name(John), Column B is their Spouse name(Jane) and Column C is t...
Since I do not think any formula is complete until it outputs a dynamic array, one could exploit a weakness of the old CONCATENATE function, which, unlike CONCAT fails to concatenate the terms of an array,
= CONCATENATE(
Table1[First Name], " & ",
Table1[Spouse Name], " ",
Table1[Last Name]
)
Note: This formula only works when placed outside the Excel Table. Inside the table, the "@" notation would be required and the table would propagate the formula down the column.