Forum Discussion

Maria1386's avatar
Maria1386
Copper Contributor
Apr 06, 2022
Solved

Help combining divided description data

I have info exported about item descriptions but the descriptions are divided into 2 cells (ie. B1 and B2)

How could I combine automatically line B2 to the end of B1.

 

UNIV ADJ INDICATOR POS
T WRCH

 should be just:

UNIV ADJ INDICATOR POST WRCH

it causes there to be 2 lines for every item. 

There are 5 columns and a warehouse of items for the rows.

 

please help 

thank you

 

excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Apr 07, 2022

    Maria1386 

     

    Put this formula into cell C1

    =B1&B2

     

    So that is the formula. It's called concatenation and can work with text easily. Any number of strings of text can be combined, just placing an ampersand character between each cell referenced.

     

2 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor
    Apr 07, 2022

    Maria1386 

     

    Put this formula into cell C1

    =B1&B2

     

    So that is the formula. It's called concatenation and can work with text easily. Any number of strings of text can be combined, just placing an ampersand character between each cell referenced.

     

Resources