Forum Discussion

BrokerJoey's avatar
BrokerJoey
Copper Contributor
Dec 05, 2022

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...
excel
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Dec 06, 2022

BrokerJoey There are couple of ways to do that. In simple you can use-

=A2&" & " & B2 & " " &C2

With CONCAT() function

=CONCAT(A2," & ",B2," ",C2)

For dynamic spill result with one formula. See the attached file.

=BYROW(A2:C6,LAMBDA(x,CONCAT(CHOOSECOLS(x,1)," & ",CHOOSECOLS(x,2)," ",CHOOSECOLS(x,3))))

 

Resources