Multiplying 2 columns- one with numbers only, one with a number &
 

Is there a way to multiply two columns if one contains text? There is no
limit as to what the number is, however, there is always a space between the
number and text.

Any help would be GREATLY appreciated.

THANKS!

Multiplying 2 columns- one with numbers only, one with a number &
 

=1*(LEFT(H1,FIND(" ",H1)-1))

will return the number in a string if the number is first.

You can use it in an array formula.

--
Regards,
Tom Ogilvy




"Kel" wrote in message
...
Is there a way to multiply two columns if one contains text? There is no
limit as to what the number is, however, there is always a space between
the
number and text.

Any help would be GREATLY appreciated.

THANKS!