SOLVED

Help combining divided description data

Copper Contributor

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

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@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.

 

@mathetes 

I knew it had to be something easy like that . Thank you!!!

 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@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.

 

View solution in original post