hi guys,
a progression on my last question
i now have a sheet where i need to concatenate 3 columns together in the format
Name1 (Position1) - Days1
I've attached the file.
Any ideas? As I can't get it to work at all.
I need to concatenate columns D, E and G with all blanks being ignored and each concatenation on a newline using the CHAR(10) function
thanks!
Bookmarks