Concatenate Multiple Lookup Values in Single Cell

[Admin]

Hi All,

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

Enjoy !

[LalitPandey87]

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.

[Nishant Choudhary]

excel fox rocks

[jnault]

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

[Admin]

Hi

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