<div>
Wow. &nbsp;Never knew it was there. &nbsp;Thanks.
</div>


Wow.  Never knew it was there.  Thanks.

<div>
You're welcome and I'm glad I was able to help. We're all learning:)<br />
<br />
Marty - MVP 2009 to 2013
</div>


You're welcome and I'm glad I was able to help. We're all learning:)

Marty - MVP 2009 to 2013

<div>
<div class="content wysiwyg-content">
I have an Excel file which contains two rows. &nbsp;There are several cases where the same exact data is duplicated in both cells in the row. &nbsp;Is there a way delete the duplicate records and leave just one record?<br />
<br />
--Steve
</div>
</div>


I have an Excel file which contains two rows.  There are several cases where the same exact data is duplicated in both cells in the row.  Is there a way delete the duplicate records and leave just one record?

--Steve

How delete duplicate records

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.