Hi All,
Here is a trick to get multiple lookup values (unique) in a single cell separated by comma.
Enjoy !
Printable View
Hi All,
Here is a trick to get multiple lookup values (unique) in a single cell separated by comma.
Enjoy !
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.