convert text & multiply
 

Is it possible to create a function/formula which will count certain text in
a row and then convert them to a value and allow it to be multiplied by a
value?
e.g. E DO L OD E L DO (count the text E, L, OD ignoring DO) the value of these being 7.5 then multiplied by the amount of times they appear e.g. 5x7.5 = 37.5.

Please refrain from multiposting, if you feel the need to post to multiple
groups crosspost, see possible answer in misc group

--
Regards,

Peo Sjoblom


"Boenerge" wrote in message
...
Is it possible to create a function/formula which will count certain text
in
a row and then convert them to a value and allow it to be multiplied by a
value?
e.g. E DO L OD E L DO (count the text E, L, OD ignoring DO) the value of
these being 7.5 then multiplied by the amount of times they appear e.g.
5x7.5 = 37.5.