Forum Discussion

wtmd's avatar
wtmd
Copper Contributor
Jan 25, 2019
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...
excel
Formulas and Functions
  • jmcl0000's avatar
    jmcl0000
    Jan 25, 2019

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

McGeheeWoolf's avatar
McGeheeWoolf
Copper Contributor
Dec 11, 2020

SergeiBaklan 

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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 11, 2020

McGeheeWoolf 

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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 12, 2020

    McGeheeWoolf 

    - select resulting column

    - copy

    - paste->paste values

    - remove source columns

  • McGeheeWoolf's avatar
    McGeheeWoolf
    Copper Contributor
    Dec 11, 2020

    McGeheeWoolf 

    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?

  • McGeheeWoolf's avatar
    McGeheeWoolf
    Copper Contributor
    Dec 11, 2020

    SergeiBaklan 

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

Resources