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!