ExcelBanter - Formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula help (https://www.excelbanter.com/excel-discussion-misc-queries/229503-formula-help.html)

I need to calculate square footage totals...The dimensions are in a single
cell (example: 132 1/4 x 52 1/8). I know that width x height (calculated as
inches) / 144 = square feet. Figuring a formula for this makes my head spin!
Any help is appreciated. THANKS! :o)

=LEFT(A1,FIND("x",A1,1)-2)*RIGHT(A1,FIND("x",A1,1)-2)/144
That is, if there is a space between the 1/4 and the x, and again between
the x and the 5 in your example
If there are no spaces, then change the first -2 to -1

--
HTH

Kassie

Replace xxx with hotmail

"rmk101575" wrote:

I need to calculate square footage totals...The dimensions are in a single
cell (example: 132 1/4 x 52 1/8). I know that width x height (calculated as
inches) / 144 = square feet. Figuring a formula for this makes my head spin!
Any help is appreciated. THANKS! :o)