UNMERGE two cells/rows in Excel

L

Larry D.

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.
 
G

Gord Dibben

Larry

In a helper column enter =A1 & A2

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


Gord Dibben Excel MVP
 
Top