How to import exponent number from Excel column to MATLAB

I have a list of numbers in excel column. I am looking to extract the exponent number (+ - symbol doesn't matter)

For example, in 2^-6 => I want '6'

in 2^-4 => I want '4'

Thank you for any help you can provide.

Answer 1

[Chunru]

x = readtable("2powx.xlsx")

x = 5×1 table
       LSB   
    _________

    {'2^-6' }
    {'2^-7' }
    {'2^-8' }
    {'2^-9' }
    {'2^-10'}

y = cellfun(@(a) sscanf(a, "%d^%d")', x.LSB, "UniformOutput", false)

y = 5×1 cell array
    {[ 2 -6]}
    {[ 2 -7]}
    {[ 2 -8]}
    {[ 2 -9]}
    {[2 -10]}

y = cell2mat(y)

y = 5×2

2 -6 2 -7 2 -8 2 -9 2 -10

y = y(:, 1).^y(:, 2)

y = 5×1

0.0156 0.0078 0.0039 0.0020 0.0010

[Ayush Ulhas]

Thank you for the help! May I know how to do the same process if the LSB values are in column 'G' and start from row '4'

[Walter Roberson]

You can specify a 'Range' option to readtable()