I have a long list of items in Excel. I have been trying to use the IF
statements to compare items in the list, so that I might delete the repeated
items.

Please note: the whole list is text. There are no numbers.

I have been trying to use

=IF(A1=A2),"same","not same"

but keep getting an error.

Please help, or perhaps suggest another function to use?