If you truly merged the columns, you lost the data in all but the left hand
column so there is nothing unmerge.

If you mean you combined the columns data using the CONCTENATE function or
the ampersand like +A1 & B1 & C1 then I would suggest trying DataText to
Columns to undo the combining after you copy/paste special/values.


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 03:12:01 -0700, Saleem <Saleem
@discussions.microsoft.com wrote:

I have some data in two or three merged columns and want to duplicate the
data in the individual columns.Pls help. Thanks