In cell B1 enter:
=LEFT(A1,5)*RIGHT(A1,6)
which displays 14.48438
--
Gary''s Student - gsnu200783


"jlclyde" wrote:

I have text that is written as 1 1/8 X 12 7/8. What I want to be able
to do is write a formula or piece of code to find the x and multiply
the 2 numbers together. So in this case 14.48. The count of
denominator changes as does having a fraction or not.

Thanks,
Jay