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 internet, but alas. No go. It keeps on saying "De bronverwijzing overlapt het bestemmingsgebied" (something like the source overlaps the destination area). If I try other things I get "Cells weren't combined".

I have absolutely no idea how to merge these cells and it is very important for our stock :( They are just text cells. F.e. 

IS CONN.E7724 DUNNE ZIT.WT SFT

 needs to merge with 

Ideal Standard - Connect - toiletzitting - extra dun - softclose - wit - easy take off

Is there too much text? Couldn't find any reference to anything on the internet (total noob, sorry).

 

Kind regards

 

Lissa

excel
Formulas and Functions

5 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    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).

Resources