| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count and convert text
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert mailing label into .xls | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Text function within Sumif | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
