Forum Discussion

yvo's avatar
yvo
Copper Contributor
Apr 17, 2018

Can't merge text cells

Hi, For work I need to enter an excel sheet into our database of products. The original Excel sheet has two columns that I need to merge together. I have used every option I have found on the intern...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 17, 2018

Hi Lissa,

 

Most probably you tried to use Consolidate in Data block of ribbon. First error is when you select both columns in references instead of one, second (no data was consolidated) simply shows that doesn't work - you can't merge two text columns with Consolidate. If only with some workaround with adding numeric column.

If something else please clarify.

 

Why don't you use formula instead to concatenate cells in these columns, like =A1&B1?

yvo's avatar
yvo
Copper Contributor
Apr 17, 2018

Hi Sergei

 

Thanks for the reply!

 

I tried =A1&B1 and even =A1&""&B1, but every time the second column colours red, so doesn't take the formula (have no idea why).

    • yvo's avatar
      yvo
      Copper Contributor
      Apr 17, 2018

      I opened your excel sheet, exactly what I had tried several times. Then I opened my sheet again and tried three times, third time all of a sudden it decides to work... (sometimes I think my computer hates me).

       

      Thanks for helping :) 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 17, 2018

        You are welcome

Resources