I am using this formula in B2 to extract the number "100" from A2 containing this text string: "viewport: 100x30".
=IFERROR(MID(A2,FIND(" ",A2)+1,FIND("x",A2)-FIND(" ",A2)-1))
All good so far.
However, I want the formula result to be formatted as a number. I am unable to change the cell format in the formula cell.
I am using Google sheets.
=IFERROR(MID(A2,FIND(" ",A2)+1,FIND("x",A2)-FIND(" ",A2)-1))
All good so far.
However, I want the formula result to be formatted as a number. I am unable to change the cell format in the formula cell.
I am using Google sheets.