UNMERGE two cells/rows in Excel
 

I copied a MS Word Table into an MS EXCEL table and some of the rows were
split into two rows when pasted into the workbook. How can I get (Merge)
all of the data data split into the cell on one row.

Larry

In a helper column enter =A1 & A2

If need a space between =A1 & " " & A2


Gord Dibben Excel MVP

On Fri, 28 Jan 2005 12:31:03 -0800, "Larry D." <Larry
wrote:

I copied a MS Word Table into an MS EXCEL table and some of the rows were
split into two rows when pasted into the workbook. How can I get (Merge)
all of the data data split into the cell on one row.