Concatenate the Corresponding Contents of Multivalue Cells

[lneidorf]

Hi there.

I have a novel issue and haven't found any threads that touch on it.

I'd like to concatenate the corresponding contents of multivalue cells across four columns. A simple illustration of my data will be helpful:


Cell A2
Boston; New York

Cell B2
Pizza Regina; White Castle

Cell C2
Sales; Marketing

Cell D2
Cash Flow Report.xls; Marketing Memo.doc


I'm looking to use a VBA loop to generate this result:

RESULT, in Cell E2
Boston\Pizza Regina\Sales\Cash Flow Report.xls; New York\White Castle\Marketing\Marketing Memo.doc


I've got thousands of rows in a spreadsheet and am trying to construct a VBA loop to automate this.

Thanks!

 

[lneidorf]

I should point out that some of my cells contain as many as 11 items separated by semi-colons. Every row in my data is different.