View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
liu liu is offline
external usenet poster
 
Posts: 17
Default calculation based on mixed entries of another cell?

I have one column with dimensions like this:
21.9" x 17.6" x 8.9"

I'd like to calculate the multiplication of the first 2 numbers. Right
now, I have to manually enter =21.9*17.6 in another cell.
I wonder if it's possible to write something that automatically picks
up 2.19 and 17.6 and multiplies the 2. The text in the column has the
same format.

Thanks in advance for the help,