Forum Discussion
Combining text from different cells into one cell
I'm trying to combine text from multiple cells into one, but the information in excel help is not working. How would I accomplish this?
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.