How I found Formula in square feet length,height in excel
Answers
Answered by
0
Answer:
Spreadsheet Formulas
Cell Formula
B1 =LEFT(A1,FIND("'",A1)-1)*SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("x ",A1)-1),"'","") & " sq ft"
B2 =LEFT(A2,FIND("'",A2)-1)*SUBSTITUTE(RIGHT(A2,LEN(A2)-FIND("x ",A2)-1),"'","") & " sq ft"
B3 =LEFT(A3,FIND("'",A3)-1)*SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("x ",A3)-1),"'","") & " sq ft"
Answered by
1
Answer:
hello good morning how are u
Similar questions