Main Profile

At A Glance

Excel Magic Trick #104: National Debt Web Query

See how to run a web query to calculate the national debt that is incurred each hour. Lern how to use the Excel Functions: The SUBSTITUITE function will remove parts of a text string and replace it with another text string (or nothing). The VALUE function converts text to a number. The MID function will extract a part of a text string from the middle of a text string The FIND function tells you what the ordinal position a certain character is in a text string (FIND is case sensitive (SEARCH is not case sensitive). The RIGHT function extracts text from a text string from the right
Length: 10:16

Contact

Questions about Excel Magic Trick #104: National Debt Web Query

Want more info about Excel Magic Trick #104: National Debt Web Query? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question