Hi All,

I am trying to open the txt file in excel, when I change Date into text to
column I get same heading repeated in between the rows, can any one give me a
macro to remove the repeated heading and remove the blank rows.

TIA