string value

  1. H

    Assign Value to each word in a string

    I am looking to assign a value to words, then total the value. I am only coming up with solutions that add one value and not all of them. Cat=1 Dog=2 Bird=3 Lizard=4 Example: <tbody> A "String" B "Solution" 1 Cat Dog Bird 6 2 Dog 2 3 Bird Lizard 7 4 Cat Dog 3 </tbody>...
  2. G

    Apply a string value to the active cell as a real formula with cell reference

    I'm halfway to solving this dilemma of mine. I have a table listing dozens of formulas some of which are custom built through a 3rd party API like Bloomberg financial(call that "FormulaTable") while others are more custom designed. A formula can be selected based on two criteria from a data...
  3. J

    Count the number of blank cells in a range, starting and ending will cells that match string values

    Greetings MrExcel forum! First time poster here, reaching out because I'm getting desperate to determine if there is a solution to my problem. I'm trying to develop a new daily timesheet for my production workers, where non-production items are recorded in 15 minute intervals. The user would...
  4. M

    NumName: Excel VBA Function to Convert Huge Long Numbers into their Numeric Word Names in a Text String Format

    I made an Excel function that converts a large string of numbers into their numeric word names. I am offering it to the community as free public domain. It has many parameters to control the desired output. You can choose USA or European names with a simple parameter change. English names are...
    • Mark Main
    • Thread
    • convert large number large numeric names string value vba function
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top