VBA: Remove duplicate data in excel cell

How to remove duplicate data (separated by semicolon) in the excel cell if found in Sheet1?

Could you post some examples?

Thanks, Rick it worked but if there is space between semicolon then the code does not work.

Originally Posted by vikim

Thanks, Rick it worked but if there is space between semicolon then the code does not work.

Saying it doesn't work gives us no clue what happened that you did not want (did the code error out? did it post wrong results? something else?). Let me take a guess... does this fix your problem (if not, provide more details)...

Please Login or Register  to view this content.

Thanks it worked. But in some cells there are double semicolon, in some cells cell data started with a semicolon or ended with a semicolon. And in some cells there is only one semicolon.

Does this modification of my code do what you want...

Please Login or Register  to view this content.

Thanks a million.