Forum Discussion
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 the proper forumla
=concatenate(a1," ",f1," ",k1," ", t1)
15 Replies
- I need the numbers in the cell A1 through A17 to be math processed and copied to cells N1 through N17
It depends on what do you want as result. Your formula doesn't work at all, you may use CONCATENATE as jmcl0000 posted or correct your formula to
=E2 &" " & H2 & " " & L2 & " " & P2
=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
- TY = works
