Excel function needed to conditionally concatenate cells
Posted on 2011-10-21
I have a worksheet with a range of columns (B - G) that may or may not have data in them. I need to seperate each cell that contains data with a semicolon (;) but ONLY if they contain data.
Column B; Column C
Column B; Column C; Column D
Column B; Column D
Column B; Column C; Column H
Note that some rows only have one item where other rows have multiple columns. Each data item must be seperated by a semicolon - but not at the end.
I'd prefer a formula instead of a macro but any help is appreciated.
Thanks in advance!