$$Excel-Macros$$ Delete rows and concatenate values.

2010-05-13 Thread siti Vi
From: maryann Date: Wed, 12 May 2010 07:56:52 -0700 (PDT) Local: Wed, May 12 2010 9:56 pm Subject: $$Excel-Macros$$ Delete rows and concatenate values. Dear VBA guru, I have a table like below: col A ColB 1 ? 1 ABD 2 ADC 2 2 ADD I would like to have results

$$Excel-Macros$$ Delete rows and concatenate values.

2010-05-12 Thread maryann
Dear VBA guru, I have a table like below: col A ColB 1 ? 1 ABD 2 ADC 2 2 ADD I would like to have results as: 1 ABD 2 ADC; ADD In other words, I would like to delete the rows with empty cell and question marks, or other unwanted values (ideally, the