Concatenate Multiple Lookup Values in Single Cell

Hi All,

Here is a trick to get multiple lookup values (unique) in a single cell separated by comma.

Enjoy !

Quote:

---

Originally Posted by Admin

Hi All,

Here is a trick to get multiple lookup values in a single cell separated by comma.

Enjoy !

---

This is the power of Formula.

excel fox rocks

Will this concatenate only everything that will fit in a cell, truncating excess that exceeds the maximum character length for the cell?

Hi

In Excel 2007, it can concatenate a total of 32767 characters.