Apr 06 2022 04:20 PM
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
Apr 06 2022 06:55 PM
Solution
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.
Apr 07 2022 10:41 AM
Apr 06 2022 06:55 PM
Solution
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.