save all ans of for loop

i split a text in cells into words cell1 "text" cell2 "text" cellE "text" but it gives me the last ans only how i can save all the rows

i try:

[num text data]= xlsread('result.xlsx','1') %import data from excel

[R C]=size(data);

for E=1:R % no of rows

d= regexp(data{E,6},'[ ]*','split');

end

how i can save all the answers?

Answer 1

[Star Strider]

Save ‘d’ as a cell array:

d{E} = regexp(data{E,6},'[ ]*','split');

[Amr Hashem]

thank you very much

it works.

but how can i save them in a cell array "row" not a column.

[Amr Hashem]

thank you a know it

d{E,1} = regexp(data{E,6},'[ ]*','split');

thanks...!!!

[Star Strider]

My pleasure.

I am not certain how your code is saving your variables.

Experiment with either:

d{E,:} = regexp(data{E,6},'[ ]*','split');

or:

d{:,E} = regexp(data{E,6},'[ ]*','split');

One of these should give you the result you want.

[Amr Hashem]

thank you very much in arabic جزاكم الله خيرا

[Star Strider]

My pleasure!