Count and convert text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a function/formula which will count 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 (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. 5 = 37.5.
 
One way:

=(LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"E",""),
"L",""),"OD"," ")))*7.5

Note the space between quotes after "OD" (to shorten the string by only
1 character per instance).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Counting text cells then multiplying by a value in another column 6
Counting help 5
Conditional Multiply and Sum 2
Calculation of weighed average 6
Relating text to a value 1
SUMPRODUCT or COUNTIF FOR TEXT VERIFIED LIST 1
formula problem> rephrased 1

Back
Top