SOLVED

New Contributor

# 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

15 Replies
best response confirmed by wtmd (New Contributor)
Solution

# Re: Excel Combing Data Cells

=concatenate(a1," ",f1," ",k1," ", t1)

# Re: Excel Combing Data Cells

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`

TY = works

# RE: Excel Combing Data Cells

I need the numbers in the cell A1 through A17 to be math processed and copied to cells N1 through N17

# Re: Excel Combing Data Cells

@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

# Re: Excel Combing Data Cells

Please check if Show Formulas is switched off

# Re: Excel Combing Data Cells

@Sergei Baklan

I clicked on Show Formulas  several times and the result is no change.

# Re: Excel Combing Data Cells

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.

# Re: Excel Combing Data Cells

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.

# Re: Excel Combing Data Cells

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.

# Re: Excel Combing Data Cells

That worked!  Thanks so much Sergei.  Have a great weekend.

# Re: Excel Combing Data Cells

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?

# Re: Excel Combing Data Cells

- select resulting column

- copy

- paste->paste values

- remove source columns

# Re: Excel Combing Data Cells

Worked beautifully.  Thanks again!

# Re: Excel Combing Data Cells

@McGeheeWoolf , you are welcome