06-02-2020 02:28 PM
06-02-2020 03:04 PM
@Chris_Hafstein there are a few options:
= A1 & B1
= concat (A1, B1)
= concatenate (A1, B1)
= textjoin ("",true,A1, B1)
06-03-2020 03:02 PM
@Chris_HafsteinYou could also use Flash Fill. In a cell type what you want the answer to look like. With the cell selected click Data > Flash Fill or press Ctrl + E.
If you don't know Flash Fill. Check it out. You won't be disappointed.
If your data is changing regularly then a formula option offered by @mtarler is better.
06-04-2020 02:03 AM
IMHO, the solution is slightly depends on what do you mean under multiple cells (are couple of them or couple hundred of cells, sequential cells or in some other order) and what means combine (with delimiter or without, with sorting or not, etc).
It's always better to provide sample file with few records and manually entered desired result.