Multiply values with labels

  • Thread starter Thread starter goodmama
  • Start date Start date
G

goodmama

Is it possible to multiply a column that contains quantities by anothe
column that cells contain labels. IE:

A1: 20 B1: 33 units sold
A2: 30 B2: 39 units sold

What I would like is a "C" column that has A1*B1 units sold


Is there a formula that carries over the text and allows for th
multiplication of 20*33 - ingnoring the "units sold" text
 
one way
=A1*VALUE(LEFT(B1,FIND(" ",B1)-1))
Click to expand...
...

Unless transition formula evaluation has been enabled, the VALUE() call is
superfluous. Also, trailing spaces don't matter. The formula

=A1*LEFT(B1,FIND(" ",B1))

should procude the desired result.
 
Back
Top