MrExcel Publishing
Your One Stop for Excel Tips & Solutions

merging cells

Posted by John H on February 11, 2002 6:05 AM


I have an excel worksgheet with 1 column. In it I have several entries that span 2 0r 3 rows. I want to merge this data so that each entry is on a new row...

Can anyone help please

Posted by JJ on February 11, 2002 7:23 AM

Use Data - Text to columns to split cells, choose delimiter, ie Space or comma etc then choose destination.