Excel Forum

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

Got a Question? Ask it Here in the Forum.