Convert text to numbers in cell where text is extracted from another cel

[ajarle]

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.

 

[hiker95]

gaz_chops,

Just another way to solve the request.

The array formula was something I had in my archives.