Deliminate text without text to columns

[jlclyde]

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

 

[Pete_UK]

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

 

[Gary''s Student]

In cell B1 enter:
=LEFT(A1,5)*RIGHT(A1,6)
which displays 14.48438

 

[jlclyde]

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




- Show quoted text -

Pete,
You have once again shown that the Anthrax song I am the Man was
written about you.
Thanks,
Jay

 

[Pete_UK]

Well, thanks for the feedback, Jay - I presume that means it worked !!
<bg>

Pete