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!

=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" <Kel@discussions.microsoft.com> wrote in message
news:556FC9F5-FA79-4AF9-A6B5-EF358F8EEF75@microsoft.com...
> 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!