[num, txt]=xlsread('Book1.xls');
txt=strrep(txt,'private','0.1');
txt=strrep(txt,'public','0.2');
txt=strrep(txt,'unemployed','0.4');
txt=strrep(txt,'employed','0.3');
Val = str2double(txt);
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!