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,
|