duplicate rows

  • Thread starter Thread starter bob engler
  • Start date Start date
B

bob engler

How do I delete duplicate sequential rows of data? They have the names and
addresses
from different sources but I only want 1 record for a mailing. Also, 2 of
the columns have
a <cr> at the beginning of the data which I need deleted also. Do I have to
write a macro
or is there an excel function I can use?

Thanks.....
 
You can use Data>Filter>Advanced Filter to copy unique data to a new
location.

To remove leading CRs, try

=IF(LEFT(A2,2)=CHAR(10)&CHAR(10),RIGHT(A2,LEN(A2)-2),A2)
 
Back
Top