Remove duplicates in excel while its in lowercase or uppercase

Hi Team,

I have some duplicates values in excel like
BOOK, book
PEN, pen
but i am not able to delete the same duplicate values while its in lowercase or Uppercase.

please tell me solution asap

Thanks & Regards
Udaya Kumar

Try this

1 Like

Hello @uday_kumar,

Here is a custom activity for remove duplicate.