View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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