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

excel

Formulas and Functions

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.

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.

Maria1386
Copper Contributor
Apr 07, 2022
mathetes
I knew it had to be something easy like that . Thank you!!!

Forum Discussion

Help combining divided description data

Resources