cell containg comma separated value in excel

i am working on excel having cells containing comma separated values like A1=1,2,3,4,5,6 and B1=3,4,5,6,7,9. i have to perform union , intersection operation on these cells. plz help me thanks and regards

Answer 1

[KSSV]

Read about xlsread, csvread, union, intersection. Your problem is pretty easy and straight forward.

[vikas]

i already tried these options but i am getting output in separate cells and i want them in single cell with comma separation

[KSSV]

You can arrange them, into one cell after you get. Attach the file and your code.

[vikas]

thanks for the reply

% i imported tha data directly to workspace as textdata
%data of first lecture
I=textdata(:,2);

II= txtdata(:,3);    % data of second lecture

% now performing the union for cell (9,8) in excel fine by coding)

f1=fopen('record.xls')
textdata{9,8}= union(I,II);
% after this everything went wrong and even dont get the idea to save union
% operation in excel directly