Going to need better detail on what you have and what you want to end up with. Also, if you have tried some things that have not worked it would be good to know what those efforts have been and why they were unsatisfactory.

The simple answer to your question is that it can be done.

From: Excel Visual Basic for Applications. [mailto:[log in to unmask]] On Behalf Of Preston, Renwick
Sent: Tuesday, February 14, 2012 7:19 AM
To: [log in to unmask]
Subject: EXTERNAL: Extracting contents of merged cells?

Is there a way programatically to extract the contents of a merged cell and put each string in its own cell?

I don't care if the unmerged data goes into a separate worksheet or even a separate workbook.