Deliminate text without text to columns
With your text in A1, put this in B1:
=TRIM(LEFT(A1,SEARCH("x",A1)-1)) * TRIM(RIGHT(A1,LEN(A1)-
SEARCH("x",A1)))
Format the cell as number with 2 decimal places.
Hope this helps.
Pete
On May 2, 1:20*pm, 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
|