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