View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mat mat is offline
external usenet poster
 
Posts: 37
Default Delete Duplicate codes in a cell

Hi Everyone,

I have cell data, arranged in rows arranged entirely in one column, each
cell contain many codes. Ideally each cell should have a unique set of codes
(could be more than one).

I would like to eliminate all the duplicate codes and keep only one of each
code.

The example cells are as follows;

FA,FA,FS,FS,FZ
FO,FA,FS,FO
FO,FO,FO

Does anyone have any idea as to what I might do in order to make the
following happen:

1) FA,FS,FZ
2) FO,FA,FS
3) FO


Any suggestions are sincerely appreciated.

Thanks Mat