# Extracting values from a cell then converting to a matrix

2 views (last 30 days)
WILLBES BANDA on 31 May 2020
Edited: Stephen23 on 31 May 2020
Hi, i have a cell array A, i want to remove column 1, row 1 and row 2 so that i am left with the other points to analyse.
A = {1x1 missing} {'Pressure'} {[ 0.0136]} {[ 0.0166]} {[ 0.0196]} {[ 0.0226]}
{'Tempera'} {[ 0.0060]} {[ 0.0074]} {[ 0.0087]} {[ 0.0100]} {[ 0.0109]}
{[ 0]} {[ 0]} {[ 0]} {[ 0]} {[ 0]} {[ 0]}
{[-0.0070]} {[-0.0095]} {[-0.0119]} {[-0.0130]} {[-0.0138]} {[-0.0140]}
{[-0.0158]} {[-0.0205]} {[-0.0251]} {[-0.0285]} {[-0.0307]} {[-0.0306]}
{[-0.0283]} {[-0.0347]} {[-0.0405]} {[-0.0455]} {[-0.0488]} {[-0.0488]}
{[-0.0442]} {[-0.0522]} {[-0.0552]} {[-0.0573]} {[-0.0588]} {[-0.0595]}
After extracting those values, i want to change them into a matrix and store them in Mat. Below is the code that i used but it gives me wrong answers. Please help.
A(:,1) = [];
A(1,:) = [];
A(1,:) = [];
CurMat = string(A);
Mat = str2double(CurSheetMat);
WILLBES BANDA on 31 May 2020
Thank you, it works. But when i use it for cells that include powers (eg 7.0000e-5) it rounds them off to four decimals, what do i do to store them exactly as they are without rounding off .

madhan ravi on 31 May 2020
Edited: madhan ravi on 31 May 2020
A([1,2],:) = [];
A(:,1) = [];
Mat = cell2mat(A)
##### 3 CommentsShow 1 older commentHide 1 older comment
madhan ravi on 31 May 2020
Use
format longg % at the beginning
WILLBES BANDA on 31 May 2020
Edited: Stephen23 on 31 May 2020
Works perfectly. Thank you once more honorable!

### Categories

Find more on Data Type Conversion in Help Center and File Exchange

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!