Deleting repeated cells in two column table (text)

[asset]

Hello,

I have a file with text, one column contains original text and another translation.
Sometimes segments repeat.
For example:

segment1 - translation1
segment1 - translation1
segment1 - translation1
segment2 - translation2
segment2 - translation2

How I can delete repeated segments?

[p45cal]

It depends on your version of Excel. If you are using Excel 2007 or later, you can use the built-in remove duplicates, see method 5 here:
http://www.mrexcel.com/tip138.shtml
otherwise use one of the other methods on that page.