Deliminate text without text to columns
 

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

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

Deliminate text without text to columns
 

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

Deliminate text without text to columns
 

On May 2, 7:36*am, Pete_UK wrote:
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- Hide quoted text -

- Show quoted text -

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

Deliminate text without text to columns
 

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

Pete

On May 2, 2:26*pm, jlclyde wrote:
Pete,
You have once again shown that the Anthrax song I am the Man was
written about you.
Thanks,
Jay