how splitting data in one column into two column in EXCEL file by MATlab?

Hi , i have excel file contains address memory from : to as example : (in excel file as attached )

4c078c:4c078f

i need to put each address in seperate column please

[~,~,datx] =  xlsread('C:\Users\testx.xlsx');

 datadd=[datx(:,1)];
 
 

Answer 1

[Nishant Gupta]

You may use readtable in place of xlsread to read the table. To seperate lowest and highest address of each address range, use strsplit function. Then use hex2dec to convert those address in decimal format and after that you can easily store the numbers in a row vector. Finally you can use dec2hex to get the address back in hexadecimal format.