View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bigbreak8ball@googlemail.com is offline
external usenet poster
 
Posts: 1
Default Unmerge cells and fill duplicate data

Add another column (B) and then add this function to fill in everything until another entry for the merged cell in col A:
=IF(A2=0,B1,A2).

This assumes you have one header.