Forum Discussion
Solved
Excel Combing Data Cells
what's the formula to combine more then (2) text data cells? specifically I want to combine cells E2 : H2 : L2 : P2 into a new cell =E2&" "&H2 "&L2 "&P2 does not yield what I want Please advise th...
=concatenate(a1," ",f1," ",k1," ", t1)
=concatenate(a1," ",f1," ",k1," ", t1)
jmcl0000 here are the two formulas I am using to try to combine the first and last name in two separate columns into one column. Neither works and only shows the formula in the cell. The formula is not executing. I have tried spacing as shown in another answer as well and the result is the same.
=concatenate(e2" "f2)
=concat(e2" "f2)
=E3 &" " & F3
I clicked on Show Formulas several times and the result is no change.
- TY = works
