View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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