Excel Concatenate - Please help, really stuck
Hello Experts,
Here is the problem, I am trying to concatenate Column A, B, C and D
into a new column.
Column A, B, C and D could have values C, R, U and D respectively. I
only need to restore unique combination while I am concatinating. In
other words, if the result is "CCRD", then I only want "CRD".
How do i do it?
Thanks for any help.
Regards.
Dip
|