Jan 25 2019 12:05 PM - edited Jan 25 2019 12:14 PM
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
Jan 26 2019 08:48 AM
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
Jan 28 2019 06:29 AM
Dec 10 2020 10:07 AM
@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
Dec 10 2020 10:22 AM
Dec 10 2020 03:37 PM
I clicked on Show Formulas several times and the result is no change.
Dec 10 2020 11:54 PM
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.
Dec 11 2020 08:37 AM
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.
Dec 11 2020 12:04 PM
Cells in this column are formatted as text
thus all what you enter is considered as text, includes formulas. You have text of formulas.
You need to apply General format (select entire column and on ribbon apply it from Home->Number section). After that re-enter formulas.
Both
=CONCATENATE(E2," ",F2)
and
=E3 &" " & F3
work. Please check in attached file.
Dec 11 2020 12:59 PM
That worked! Thanks so much Sergei. Have a great weekend.
Dec 11 2020 01:17 PM
Is there a way after the first and last names are combined that I can somehow change the formatting of the eliminate the two source columns (E and F) and have the result remain?
Dec 12 2020 04:07 AM
Jan 25 2019 02:15 PM
Solution=concatenate(a1," ",f1," ",k1," ", t1)