Forum Discussion
Excel Combing Data Cells
=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.
It works as a trigger, each time you click on it it changes behavior of the formulas entered. If Show formulas highlighted, it shows formulas, otherwise result of calculations.
Another variant is that cells into which you enter formulas are formatted as texts.
Perhaps it could be more exotic cases, it takes time to make all guesses. Small sample file instead of PDF could shorten this discussion dramatically.
Thanks so much for the assistance. I want to combine the first and last name in columns E and F respectively with the result in column D. First name first.
See attached.