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
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.