How do you get the breadth of a question?

N

N Harkawat

if your result is shown as it is that is 36cm2 instead of the number 36
cell A1 = 36cm2
B1 = 9cm
on cell C1 type this
=--SUBSTITUTE(A1,"cm2","")/--SUBSTITUTE(B1,"cm","")

Now this formula will only work if the cells have cm2 and cm respectively
if they are different like sqft etc.. then you will need a different formula

However if its plain 36 and 9 then its simply
=a1/b1

However if you
 
Top